RE: Multiple lookups for one item in one description table

On 29 May 2003 at 11:38, James wrote: > What we envision is a query to return something similar to this: > > +-+--++ > | Item Number | Item Description | Option Description | > +-+--++ > | 1

RE: Multiple lookups for one item in one description table

Thanks for your reply Jeff. While your query is more efficient than the one we had, it still poses the fundamental problem we were trying to avoid; that is returning a "row" for each option. Our "item" table contains over 280 fields which about 30 of them are multiple look-ups like the one I desc

Re: Multiple lookups for one item in one description table

James, What you are describing is a many-to-many relationship and is very commonly done. You should be able to get your desired output using your existing structure with something like: SELECT i.item_id AS "Item Number", i.item_desc AS "Item Description", o.option_desc AS "Optio