Need Help with Joins

[usa_dreamer2002]

Hi all,
I have a table with few records as follows:

id record1 firstvalue secondvalue
01 1111 12 0


02 1111 0 2
etc
I want to have all similar records in one line like

01 1111 12 2

I will appreciate any input

[pbaldy]

Based on your example

SELECT record1, Max(firstvalue) As MaxFirst, Max(secondvalue) AS MaxSecond
FROM TableName
GROUP BY record1

[usa_dreamer2002]

Sorry for the late response. That solved my problem. Thanks a million. Don't know how mark the post solved thus.

[pbaldy]

No problem and welcome to the site by the way. Thread can be marked solved via the "Thread Tools" link at the top, but I'll do it since I'm already here.