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
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?