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:
01082700
Vues:
10
You're missing commas between most of the columns and ';' is so VFP. :)

>SQL Query Analyzer is returning:
>
>
Line 2: Incorrect syntax near '                    '.
>
>
>
>
>
>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