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 '>You're welcome.
>>>SELECT CAST(0 AS bit) AS checked, >>>... >>>>>>>Ok, now it doesn't like the 'FALSE'. Whats the correct way to