Here's one way, not sure if it's the best way. I put the create table stuff in there just so you can see how it works. You will only need that select statement atthe bottom, and do some slight modification to it. create table #gminfo(RecordId INT, greeting varchar(50))Create table #gmin_phone(RecordId INT, Phone varchar(50))INSERT INTO #gminfo(RecordId, greeting) VALUES(1, 'Hello 1')INSERT INTO #gminfo(RecordId, greeting) VALUES(2, 'Hello 2')INSERT INTO #gminfo(RecordId, greeting) VALUES(3, 'Hello 3')INSERT INTO #gminfo(RecordId, greeting) VALUES(4, 'Hello 4')INSERT INTO #gminfo(RecordId, greeting) VALUES(5, 'Hello 5')INSERT INTO #gmin_phone(RecordId, Phone) VALUES(1, '111111111')INSERT INTO #gmin_phone(RecordId, Phone) VALUES(1, '111111112')INSERT INTO #gmin_phone(RecordId, Phone) VALUES(1, '111111113')INSERT INTO #gmin_phone(RecordId, Phone) VALUES(2, '222222221')INSERT INTO #gmin_phone(RecordId, Phone) VALUES(2, '222222222')INSERT INTO #gmin_phone(RecordId, Phone) VALUES(2, '222222223')INSERT INTO #gmin_phone(RecordId, Phone) VALUES(3, '333333331')INSERT INTO #gmin_phone(RecordId, Phone) VALUES(4, '444444441')INSERT INTO #gmin_phone(RecordId, Phone) VALUES(5, '555555551')SELECT info.*, (SELECT TOP 1 phone.phone FROM #gmin_phone phone WHERE phone.RecordId = info.RecordId)FROM #gminfo info
Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> 
Help with Query.
Posted - 2002-08-26 : 12:31:23
