You're welcome.
>Thanks Sergey!
>
>>
SELECT ...
>> FROM Document doc
>> JOIN Client cl ON cl.id = doc.client
>> JOIN Station st ON st.id = doc.station
>> JOIN Show_title sht ON sht.id = mo.show_title
>> JOIN Media_Order mo ON mo.DOcument = doc.id
>> JOIN Media_Order_Detail mod ON mod.Media_Order = mo.id
>>
>>
>>>I have 6 tables from which I need to pull data. I'm not sure how to
>>>code this as a single command to pass to SQL. Any help would be
>>>greatly appreciated.
>>>
>>>Please see this diagram:
>>>
http://home.comcast.net/~kmarois/sql1.jpg>>>
>>>
>>>I need the followng fields:
>><snip>
--sb--