>SELECT CAST(0 AS bit) AS checked, > ' ' AS invoiceid, > ' ' AS ISCI, > ' ' AS dayofweek, > ' ' AS Phone, > doc.id AS docid, > doc.station, > doc.client, > mo.show_title, > mo.order_rate AS gross, > mo.program_name, > mo.order_qty AS ordqty, > mo.id AS line_id, > mod.actual_air_date, > mod.actual_air_time > FROM Document doc > JOIN Client cl ON cl.id = doc.client > JOIN Station st ON st.id = doc.station > JOIN Media_Order mo ON mo.Document = doc.id > JOIN Show_title sht ON sht.id = mo.show_title > JOIN Media_Order_Detail mod ON mod.Media_Order = mo.id > WHERE st.id = 733 AND > actual_air_date between '2005-07-01 00:00:00.000' and '2005-07-31 00:00:00.000 > > ** The WHERE clause would normally be built on the fly. > >'>
>>>>SELECT CAST(0 AS bit) AS checked, >>>>... >>>>>>>>>Ok, now it doesn't like the 'FALSE'. Whats the correct way to