SELECT DISTINCT

p.OrderNum

--,r.LabNum

--,r.Lab_C

--,r.Flag

--,r.Value

FROM

@Orders AS p

INNER JOIN...

I have corrected my English above Sir.

My Script has your name and Link to the post in the documentation. I posted here so that somebody else could find the...

Thanks for all the help!

Edit....Out of all the offerings, this one seemed to work the best when testing

DECLARE@Orders TABLE

(

LabNum VARCHAR(9) NOT NULL,

OrderNum CHAR(8) NOT NULL

);

INSERT@Orders

(

LabNum,

OrderNum

)

VALUES('A29E02FE', 'D2C6DDA8'),

('4A563D24', 'D2C6DDA8'),

('0F53BC60', 'DC01E4EB'),

('GS43A689', 'DC01E4EB'),

('F943C7034',...

Ha....got to love NextGen!!

Thank you for your reply and I will read your article about posting

However, both examples fail to evaluate all records in the related table before returning the OrderNum

If an OrderNum...