Posted by John Bokma on 03/21/06 00:05

I have a table A, with two ID columns. In a report both ID colums should
be shown with the actual value stored in a second table, B

The problem is, both IDs need to be looked up in B, but are not in the
same row.

How do I do this in an efficient way? A sub select?

Thanks,

--
John MexIT: http://johnbokma.com/mexit/
personal page: http://johnbokma.com/
Experienced programmer available: http://castleamber.com/
Happy Customers: http://castleamber.com/testimonials.html

• Next in forum: Re: Reporting a table with two columns from another table
• Prev in forum: Re: Dell Raid 0+1
• Thread view: Reporting a table with two columns from another table

[Reply to this message]