| Groups | Blog | Home |
sql server new users : PROBLEM WITH SQL QUERY STATEMENT
I am getting an error message from the following query using Crystal reports 8.5,win98OS,SQL Server 2000. Your help is really appreciated Error message : Syntax error near }. Can I use oj syntax twice in a query??? SELECT DISTINCT National_Oxygen_TEST_Customer."Name", National_Oxygen_TEST_Customer_Budget."Year", National_Oxygen_TEST_Customer_Budget."Feb Amount", National_Oxygen_TEST_Customer_Budget."Apr Amount", National_Oxygen_TEST_Customer_Budget."May Amount", National_Oxygen_TEST_Customer_Budget."Jan Volume", National_Oxygen_TEST_Customer_Budget."Feb Volume", National_Oxygen_TEST_Customer_Budget."Mar Volume", National_Oxygen_TEST_Customer_Budget."Apr Volume", National_Oxygen_TEST_Customer_Budget."May Volume", National_Oxygen_TEST_Item."No_", National_Oxygen_TEST_Item."Item Category Code", National_Oxygen_TEST_Item."Is Bulk", National_Oxygen_TEST_Item."Sales SM3", National_Oxygen_TEST_Item."Production SM3", National_Oxygen_TEST_Item."Liquid Volume", National_Oxygen_TEST_Item."CK Reporting Unit", National_Oxygen_TEST_Item."CK Gas Reporting Unit", National_Oxygen_TEST_Item_Category."Code", National_Oxygen_TEST_Item_Category."Description", National_Oxygen_TEST_Sales_Invoice_Header."No_", National_Oxygen_TEST_Sales_Invoice_Header."Sell-to Customer No_", National_Oxygen_TEST_Sales_Invoice_Header."Posting Date", National_Oxygen_TEST_Sales_Invoice_Line."Document No_", National_Oxygen_TEST_Sales_Invoice_Line."No_", National_Oxygen_TEST_Sales_Invoice_Line."Line Amount" FROM {oj (((((("noxtest"."dbo"."National Oxygen TEST$Sales Invoice Header" National_Oxygen_TEST_Sales_Invoice_Header INNER JOIN "noxtest"."dbo"."National Oxygen TEST$Sales Invoice Line" National_Oxygen_TEST_Sales_Invoice_Line ON National_Oxygen_TEST_Sales_Invoice_Header."No_" = National_Oxygen_TEST_Sales_Invoice_Line."Document No_") LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Item" National_Oxygen_TEST_Item ON National_Oxygen_TEST_Sales_Invoice_Line."No_" = National_Oxygen_TEST_Item."No_") LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Customer Budget" National_Oxygen_TEST_Customer_Budget ON National_Oxygen_TEST_Sales_Invoice_Line."Sell-to Customer No_" = National_Oxygen_TEST_Customer_Budget."Customer No_") LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Customer" National_Oxygen_TEST_Customer ON National_Oxygen_TEST_Sales_Invoice_Line."Sell-to Customer No_" = National_Oxygen_TEST_Customer."No_") LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Item Category" National_Oxygen_TEST_Item_Category ON National_Oxygen_TEST_Item."Item Category Code" = National_Oxygen_TEST_Item_Category."Code"} LEFT OUTER JOIN (SELECT National_Oxygen_TEST_Sales_Cr_Memo_Header."No_", National_Oxygen_TEST_Sales_Cr_Memo_Line."Line Amount" FROM {oj ("noxtest"."dbo"."National Oxygen TEST$Sales Cr_Memo Header" National_Oxygen_TEST_Sales_Cr_Memo_Header INNER JOIN "noxtest"."dbo"."National Oxygen TEST$Sales Cr Memo Line" National_Oxygen_TEST_Sales_Cr_Memo_Line) ON National_Oxygen_TEST_Sales_Cr_Memo_Header."No_" = National_Oxygen_TEST_Sales_Cr_Memo_Line."Document No_"}))}
Braces - { and } - are not supported in SQL Server. Use parentheses.
-- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com .. [quoted text, click to view] "Radharaj" <Radharaj@discussions.microsoft.com> wrote in message Hinews:F345A119-21B5-4265-9B62-3A8DEE23C28B@microsoft.com... I am getting an error message from the following query using Crystal reports 8.5,win98OS,SQL Server 2000. Your help is really appreciated Error message : Syntax error near }. Can I use oj syntax twice in a query??? SELECT DISTINCT National_Oxygen_TEST_Customer."Name", National_Oxygen_TEST_Customer_Budget."Year", National_Oxygen_TEST_Customer_Budget."Feb Amount", National_Oxygen_TEST_Customer_Budget."Apr Amount", National_Oxygen_TEST_Customer_Budget."May Amount", National_Oxygen_TEST_Customer_Budget."Jan Volume", National_Oxygen_TEST_Customer_Budget."Feb Volume", National_Oxygen_TEST_Customer_Budget."Mar Volume", National_Oxygen_TEST_Customer_Budget."Apr Volume", National_Oxygen_TEST_Customer_Budget."May Volume", National_Oxygen_TEST_Item."No_", National_Oxygen_TEST_Item."Item Category Code", National_Oxygen_TEST_Item."Is Bulk", National_Oxygen_TEST_Item."Sales SM3", National_Oxygen_TEST_Item."Production SM3", National_Oxygen_TEST_Item."Liquid Volume", National_Oxygen_TEST_Item."CK Reporting Unit", National_Oxygen_TEST_Item."CK Gas Reporting Unit", National_Oxygen_TEST_Item_Category."Code", National_Oxygen_TEST_Item_Category."Description", National_Oxygen_TEST_Sales_Invoice_Header."No_", National_Oxygen_TEST_Sales_Invoice_Header."Sell-to Customer No_", National_Oxygen_TEST_Sales_Invoice_Header."Posting Date", National_Oxygen_TEST_Sales_Invoice_Line."Document No_", National_Oxygen_TEST_Sales_Invoice_Line."No_", National_Oxygen_TEST_Sales_Invoice_Line."Line Amount" FROM {oj (((((("noxtest"."dbo"."National Oxygen TEST$Sales Invoice Header" National_Oxygen_TEST_Sales_Invoice_Header INNER JOIN "noxtest"."dbo"."National Oxygen TEST$Sales Invoice Line" National_Oxygen_TEST_Sales_Invoice_Line ON National_Oxygen_TEST_Sales_Invoice_Header."No_" = National_Oxygen_TEST_Sales_Invoice_Line."Document No_") LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Item" National_Oxygen_TEST_Item ON National_Oxygen_TEST_Sales_Invoice_Line."No_" = National_Oxygen_TEST_Item."No_") LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Customer Budget" National_Oxygen_TEST_Customer_Budget ON National_Oxygen_TEST_Sales_Invoice_Line."Sell-to Customer No_" = National_Oxygen_TEST_Customer_Budget."Customer No_") LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Customer" National_Oxygen_TEST_Customer ON National_Oxygen_TEST_Sales_Invoice_Line."Sell-to Customer No_" = National_Oxygen_TEST_Customer."No_") LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Item Category" National_Oxygen_TEST_Item_Category ON National_Oxygen_TEST_Item."Item Category Code" = National_Oxygen_TEST_Item_Category."Code"} LEFT OUTER JOIN (SELECT National_Oxygen_TEST_Sales_Cr_Memo_Header."No_", National_Oxygen_TEST_Sales_Cr_Memo_Line."Line Amount" FROM {oj ("noxtest"."dbo"."National Oxygen TEST$Sales Cr_Memo Header" National_Oxygen_TEST_Sales_Cr_Memo_Header INNER JOIN "noxtest"."dbo"."National Oxygen TEST$Sales Cr Memo Line" National_Oxygen_TEST_Sales_Cr_Memo_Line) ON National_Oxygen_TEST_Sales_Cr_Memo_Header."No_" = National_Oxygen_TEST_Sales_Cr_Memo_Line."Document No_"}))}
[quoted text, click to view]
Tom Moreau wrote: > Braces - { and } - are not supported in SQL Server. Use parentheses. > This is a sql dump from crystal reports... the issue I see is that you have 2 from clauses... there should only be one... clean up the second one and either remove it, or add it as a join or (gulp) a union... and try again.
thanks a lot tom. i reorganised the query and it works
[quoted text, click to view] "Radharaj" wrote:
> Hi > > I am getting an error message from the following query using Crystal reports > 8.5,win98OS,SQL Server 2000. Your help is really appreciated > > Error message : Syntax error near }. > > Can I use oj syntax twice in a query??? > > SELECT DISTINCT > National_Oxygen_TEST_Customer."Name", > National_Oxygen_TEST_Customer_Budget."Year", > National_Oxygen_TEST_Customer_Budget."Feb Amount", > National_Oxygen_TEST_Customer_Budget."Apr Amount", > National_Oxygen_TEST_Customer_Budget."May Amount", > National_Oxygen_TEST_Customer_Budget."Jan Volume", > National_Oxygen_TEST_Customer_Budget."Feb Volume", > National_Oxygen_TEST_Customer_Budget."Mar Volume", > National_Oxygen_TEST_Customer_Budget."Apr Volume", > National_Oxygen_TEST_Customer_Budget."May Volume", > National_Oxygen_TEST_Item."No_", > National_Oxygen_TEST_Item."Item Category Code", > National_Oxygen_TEST_Item."Is Bulk", > National_Oxygen_TEST_Item."Sales SM3", > National_Oxygen_TEST_Item."Production SM3", > National_Oxygen_TEST_Item."Liquid Volume", > National_Oxygen_TEST_Item."CK Reporting Unit", > National_Oxygen_TEST_Item."CK Gas Reporting Unit", > National_Oxygen_TEST_Item_Category."Code", > National_Oxygen_TEST_Item_Category."Description", > National_Oxygen_TEST_Sales_Invoice_Header."No_", > National_Oxygen_TEST_Sales_Invoice_Header."Sell-to Customer No_", > National_Oxygen_TEST_Sales_Invoice_Header."Posting Date", > National_Oxygen_TEST_Sales_Invoice_Line."Document No_", > National_Oxygen_TEST_Sales_Invoice_Line."No_", > National_Oxygen_TEST_Sales_Invoice_Line."Line Amount" > FROM > {oj (((((("noxtest"."dbo"."National Oxygen TEST$Sales Invoice Header" > National_Oxygen_TEST_Sales_Invoice_Header INNER JOIN > "noxtest"."dbo"."National Oxygen TEST$Sales Invoice Line" > National_Oxygen_TEST_Sales_Invoice_Line ON > National_Oxygen_TEST_Sales_Invoice_Header."No_" = > National_Oxygen_TEST_Sales_Invoice_Line."Document No_") > LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Item" > National_Oxygen_TEST_Item ON National_Oxygen_TEST_Sales_Invoice_Line."No_" = > National_Oxygen_TEST_Item."No_") > LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Customer Budget" > National_Oxygen_TEST_Customer_Budget ON > National_Oxygen_TEST_Sales_Invoice_Line."Sell-to Customer No_" = > National_Oxygen_TEST_Customer_Budget."Customer No_") > LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Customer" > National_Oxygen_TEST_Customer ON > National_Oxygen_TEST_Sales_Invoice_Line."Sell-to Customer No_" = > National_Oxygen_TEST_Customer."No_") > LEFT OUTER JOIN "noxtest"."dbo"."National Oxygen TEST$Item Category" > National_Oxygen_TEST_Item_Category ON National_Oxygen_TEST_Item."Item > Category Code" = National_Oxygen_TEST_Item_Category."Code"} > LEFT OUTER JOIN (SELECT > National_Oxygen_TEST_Sales_Cr_Memo_Header."No_", > National_Oxygen_TEST_Sales_Cr_Memo_Line."Line Amount" > FROM > {oj ("noxtest"."dbo"."National Oxygen TEST$Sales Cr_Memo Header" > National_Oxygen_TEST_Sales_Cr_Memo_Header INNER JOIN > "noxtest"."dbo"."National Oxygen TEST$Sales Cr Memo Line" > National_Oxygen_TEST_Sales_Cr_Memo_Line) ON > National_Oxygen_TEST_Sales_Cr_Memo_Header."No_" = > National_Oxygen_TEST_Sales_Cr_Memo_Line."Document No_"}))} >
thanks a lot ryan. i split the query and it works
[quoted text, click to view] "Ryan Schellenberg" wrote:
> Tom Moreau wrote: > > Braces - { and } - are not supported in SQL Server. Use parentheses. > > > > > This is a sql dump from crystal reports... > the issue I see is that you have 2 from clauses... there should only be > one... > clean up the second one and either remove it, or add it as a join or > (gulp) a union... and try again. > -ryan schellenberg
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |