>>Hi Ken,
>>
>>Without knowing the fields you want, or the names of the detail tables, here's my best guess at what you're looking for:
>>
>>-- code snip follows --
>>
>>SELECT ALL ;
>> SoMaster.Field1, ;
>> SoMaster.Field2, ;
>> SoDetail1.Field1, ;
>> SoDetail1.Field2, ;
>> SoDetail2.Field1, ;
>> SoDetail2.Field2, ;
>> ;
>>FROM SoDetail2, SODetail1, SoMaster ;
>>WHERE SoDetail2.ItemNo = SoDetail1.ItemNo ;
>>AND SoDetail1.SoNumber = SoMaster.SoNumber
>>
>>-- end code snip --
>>
>>You don't need to link the two detail tables together, since you're already linking the master to the first detail table and there's a common link between the two detail tables.
>>
>>Evan Pauley
>>
>>
>>Ken Morehouse wrote:
>>>Hello all,
>>>This is probably a question that has been asked numerous times, but I have an urgency.
>>>
>>>Scenario:
>>>1 Sales Order Master Table and 2 detail tables
>>>I need to select all SO's for a given customer from the master.(This is no problem). Next I need to select the item detail from 2 separate tables. the 2 detail tables need to link to the master by SOnumber, and to each other by SOnumber and ItemNumber.
>>>
>>>Any ideas? I'm racking my brain on this one. I have fallen on the wayside from coding anymore, but need to get this project out for the sales dept ASAP. ANY HELP WILL BE GREATLY APPRECIATED!!
>>>
>>>Thanks in advance,
>>>Ken Morehouse, MCP
>
>
>THANKS A MILLION!!! That was what I needed.

That worked??

Erik Moore
Clientelligence