Re: I'm getting message 'Syntax error in WHERE clause'

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 05/12/04 

Date: Wed, 12 May 2004 06:16:00 -0700

The SQL code is as follows:

SELECT [Orders].[SupplierID], [Suppliers].[Address] AS
Suppliers_Address, [Suppliers].[Address2], [Suppliers].
[City] AS Suppliers_City, [Suppliers].[Region] AS
Suppliers_Region, [Suppliers].[PostalCode] AS
Suppliers_PostalCode, [Suppliers].[Country] AS
Suppliers_Country, [Orders].[CustomerID], [Customers].
[Address] AS Customers_Address, [Customers].[Address1],
[Customers].[City] AS Customers_City, [Customers].[Region]
AS Customers_Region, [Customers].[PostalCode] AS
Customers_PostalCode, [Customers].[Country] AS
Customers_Country, [Orders].[DeliveryName], [Orders].
[DeliveryAddress], [Orders].[DeliveryAddress2], [Orders].
[DeliveryCity], [Orders].[DeliveryRegion], [Orders].
[DeliveryPostalCode], [Orders].[DeliveryCountry], [Orders].
[TransporterID], [Transporters].[TelNo], [Transporters].
[FaxNo], [Orders].[TransporterRate], [Orders].[OrderID],
[Orders].[SalesID], [Orders].[PSNo], [Orders].[Notes],
[Orders].[OrderDate], [Orders].[RequiredDate], [Order
Details].[ProductID], [Order Details].[UnitPrice], [Order
Details].[ProductCode], [Order Details].[NoCases], [Order
Details].[WeightEach], [Order Details].[Quantity], [Order
Details].[CostPrice], [Order Details].[Stock Ref], [Order
Details].[SaleCurrency], [Order Details].[CostCurrency],
[Orders].[Agent], [Orders].[CollectionDate], [Suppliers].
[E-Mail], [Suppliers].[ContactName], [Customers].[E-Mail],
[Customers].[ContactName], [Order Details].[NoPallets],
[Orders].[ReleaseNo], [Orders].[CollName], [Orders].
[CollAddress], [Orders].[CollAddress2] FROM Transporters
INNER JOIN (Suppliers INNER JOIN ((Customers INNER JOIN
Orders ON [Customers].[CustomerID]=[Orders].[CustomerID])
INNER JOIN [Order Details] ON [Orders].[OrderID]=[Order
Details].[OrderID]) ON [Suppliers].[SupplierID]=[Orders].
[SupplierID]) ON [Transporters].[TransporterID]=[Orders].
[TransporterID] WHERE

>-----Original Message-----
>Steve
>
>Without the SQL statement to look at, and maybe some idea
of your data
>structure, we could only guess what might be wrong...
>
>--
>More info, please ...
>
>Jeff Boyce
><Access MVP>
>
>.
>

Relevant Pages

  • Duanes SQL Documenter Code
    ... When I run the documenter on my PC (Windows ME), ... FROM (doc_tblObjects AS doc_tblObjects_2 INNER JOIN doc_tblObjects AS ... My question is related to the SQL code. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Collection Vs SQL tables!!
    ... as a inner join v_RA_System_SMSAssignedSites as b on ... This query will show you the duplicates. ... Total no of non-obsolete clients in collection=709 ... Is there any tuning can be done in my SQL code so that i get the same count ...
    (microsoft.public.sms.admin)
  • Re: Missing Data
    ... The SQL code is below. ... tabel "data" is the main table. ... FROM INNER JOIN (((data INNER JOIN dblist ON ... data.JobNo = dblist.jobno) INNER JOIN Methodology ON data. ...
    (microsoft.public.access.queries)
  • Re: Lookup Based on Multiple Criteria
    ... Here is the sql code to determine child ... code and possible rates per provider. ... FROM tblChildren INNER JOIN (tblProviders INNER JOIN ...
    (microsoft.public.access.modulesdaovba)
  • Re: Syntax Error
    ... "John Spencer" wrote: ... Access drives me crazy with all the parentheses it uses. ... Suppliers INNER JOIN ... Methods].FROM Suppliers INNER JOIN (Products INNER ...
    (microsoft.public.access.reports)