Re: sql question

In article <4i9vda$f8b_at_news.eecs.uic.edu>, Rajasekhar Gunturu (rgunturu_at_ernie.eecs.uic.edu) says...
!>
!>i have 2 records in a table of the following format:
!>
!>A B C
!>------------------
!>AAA 10 (B is null)
!> BBB 10 (A is null)
!>
!>I'd like to combine such records into a single record, of the form:
!>
!>A B C
!>------------------
!>AAA BBB 10
!>
!>
!>Is this possible? If so, how?
!>
!>thanks,
!>raj
!>(rgunturu_at_eecs.uic.edu)
!>--

would
select max(A), max(B), C
 from rajs_table
 group by C;
do the trick?

-- 
Kind reGards
     \ /   |
      X    |
     / \   s
     Gerard