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>