Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's Wrong With This Syntax?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01082695
Message ID:
01082745
Views:
9
Now you have to many commas. Remove the one after the last column.

>Ok, now it's complaining near the FROM:
>
>
>SELECT FALSE AS checked,
>	  '                    ' AS invoiceid,
>	  '                    ' AS ISCI,
>	  '  ' AS dayofweek,
>	  '          ' AS Phone,
>	  doc.id AS docid,
>	  doc.station,
>	  doc.client,
>	  mod.actual_air_date,
>	  mod.actual_air_time,
>	  mo.show_title,
>	  mo.order_rate AS gross,
>	  mo.program_name,
>	  mo.order_qty AS ordqty,
>	  mo.id AS line_id,
>  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 doc.id = 14113
>
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform