|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-28 : 08:16:35
|
| Raj writes "HiPls help me on the following error message from crystal reports 8.5 ,win98 OS ,SQL SERVER 2000 databaseSELECT National_Oxygen_TEST_Customer_Budget."Year", National_Oxygen_TEST_Customer_Budget."Jan Amount", National_Oxygen_TEST_Customer_Budget."Feb Amount", National_Oxygen_TEST_Customer_Budget."Mar Amount", National_Oxygen_TEST_Customer_Budget."Apr Amount", National_Oxygen_TEST_Customer_Budget."May Amount", National_Oxygen_TEST_Customer_Budget."Jun Amount", National_Oxygen_TEST_Customer_Budget."Jul Amount", National_Oxygen_TEST_Customer_Budget."Aug Amount", National_Oxygen_TEST_Customer_Budget."Sep Amount", National_Oxygen_TEST_Customer_Budget."Oct Amount", National_Oxygen_TEST_Customer_Budget."Nov Amount", National_Oxygen_TEST_Customer_Budget."Dec 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_Customer_Budget."Jun Volume", National_Oxygen_TEST_Customer_Budget."Jul Volume", National_Oxygen_TEST_Customer_Budget."Aug Volume", National_Oxygen_TEST_Customer_Budget."Sep Volume", National_Oxygen_TEST_Customer_Budget."Oct Volume", National_Oxygen_TEST_Customer_Budget."Nov Volume", National_Oxygen_TEST_Customer_Budget."Dec 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."Sales NM3", National_Oxygen_TEST_Item."Production SM3", National_Oxygen_TEST_Item."Production NM3", National_Oxygen_TEST_Item_Category."Code", National_Oxygen_TEST_Item_Category."Description", National_Oxygen_TEST_Sales_Cr_Memo_Header."No_", National_Oxygen_TEST_Sales_Cr_Memo_Header."Sell-to Customer No_", National_Oxygen_TEST_Sales_Cr_Memo_Header."Posting Date", National_Oxygen_TEST_Sales_Cr_Memo_Line."No_", National_Oxygen_TEST_Sales_Cr_Memo_Line."Document No_", National_Oxygen_TEST_Sales_Cr_Memo_Line."Line Amount", National_Oxygen_TEST_Sales_Cr_Memo_Line."Item Category Code", National_Oxygen_TEST_Sales_Invoice_Line."Sell-to Customer No_", National_Oxygen_TEST_Sales_Invoice_Line."No_", National_Oxygen_TEST_Sales_Invoice_Line."Line Amount", 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" 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_") 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_") INNER 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_" AND National_Oxygen_TEST_Sales_Invoice_Line."Item Category Code" = National_Oxygen_TEST_Customer_Budget."Item Code") INNER JOIN "noxtest"."dbo"."National Oxygen TEST$Item Category" National_Oxygen_TEST_Ite |
|
Error in SQL Query 