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:

0000 as linenum
.f. as checked
space(20) as invoiceid
SPACE(20) as ISCI
doc.id as docid
mod.actual_air_date
mod.actual_air_time
mo.order_rate as gross
SPACE(10) as Phone
mo.program_name
mo.order_qty as ordqty
mo.id as line_id
space(2) as dayofweek

station.station_name         
client.client_code
client.client_name
shows.show_title            

Thanks!