asked
Error: Incorrect Syntax when adding constants
I am trying to add constants to a query to fill columns as I am doing a union all and one of the views I am querying doesn't have all the relevent columns. My code is thus: SELECT Date, Period, Code, NetAmount, Ref, Details, Site, TransRef, [Supp Code] AS Supplier, [Supplier Name] AS SupplierName, OurRef FROM dbo.vw_bsMET Union All SELECT Date, Period, Code, NetAmount, Ref, 'Details, Site, TransRef, [Supp Code], [Supplier Name], Ref2 AS OurRef FROM dbo.vw_plMET Union All SELECT Date, Period, 'Code' AS Code, NetAmount, 'Creditor' AS Ref, 'Creditors' AS Details, 'Site' AS Site, Ref AS TransRef, Supplier, SupplierName, InvRef AS OurRef FROM dbo.vw_SuppMET I get an error as follows: ![alt text][1] The Constants are in the third select ... 'Code' 'Creditor' 'Creditors' 'Site' I am not sure where I am going wrong ! [1]: /storage/temp/1762-sql1.jpg
Hi Peter. I don't think you need those single quotes at all so it doesn't really matter where it's going wrong. Just take them out and you should be fine.
Actually it was simpler than that. I had a rogue ' in the middle of teh second Select statement which is obvious in the pasted code above as it turns everything green i.e. a comment. I now just have to fix a collation error!
15 People are following this question.
