>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
If I understand you correctly, you are describing a cyclical relationship, which is illegal withing a single query. Could you explain more as to how the two child tables are related conceptually?
Erik Moore
Clientelligence