Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's Wrong With This Syntax?
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01082695
Message ID:
01082745
Vues:
8
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--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform