DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: sql error message...please help

  1. #1
    Phil Weber Guest

    Re: sql error message...please help

    > I am getting an error stating that I am missing an operator
    > with the following SQL...I don't see anything wrong.


    Heather: Nor do I. Does the SQL work in SQL Query Analyzer? Could the error
    be caused by the code you're using to execute the SQL, rather than the SQL
    itself?
    ---
    Phil Weber



  2. #2
    Heather Boyles Guest

    sql error message...please help


    I am getting an error stating that I am missing an operator with the following
    sql:

    SELECT Customers.[Customer Name], [LIST Sales Tax Codes].[Tax Code],
    [LIST Payment Terms].[Terms Name]
    FROM Customers LEFT OUTER JOIN
    [LIST Payment Terms] ON Customers.[Terms ID] = [LIST
    Payment Terms].[Terms ID] LEFT OUTER JOIN
    [LIST Sales Tax Codes] ON Customers.[Tax Code 1] =
    [LIST Sales Tax Codes].[Tax Code ID]



    I don't see anything wrong.

  3. #3
    Heather Guest

    Re: sql error message...please help


    "Phil Weber" <pweber@nospam.fawcette.com> wrote:
    > > I am getting an error stating that I am missing an operator
    > > with the following SQL...I don't see anything wrong.

    >
    >Heather: Nor do I. Does the SQL work in SQL Query Analyzer? Could the error
    >be caused by the code you're using to execute the SQL, rather than the SQL
    >itself?
    >---
    >Phil Weber
    >
    >


    No, I am running the SQL code in the query builder itself. It is strange.
    Why is the query builder so flaky. I never had this many problems with
    the query builder in ms access

    Heather


  4. #4
    Al Guten Guest

    Re: sql error message...please help


    Hi Heather,

    First try each of the two Joins alone to ensure your data is valid. If both
    of those work separately, then put them toghether and try adding parenthesis
    () around the last join. Just guessing as I dont know your data or table
    structure.

    -Al

    "Heather Boyles" <hboyles@pdan.com> wrote:
    >
    >I am getting an error stating that I am missing an operator with the following
    >sql:
    >
    >SELECT Customers.[Customer Name], [LIST Sales Tax Codes].[Tax Code],
    >[LIST Payment Terms].[Terms Name]
    >FROM Customers LEFT OUTER JOIN
    > [LIST Payment Terms] ON Customers.[Terms ID] = [LIST
    >Payment Terms].[Terms ID] LEFT OUTER JOIN
    > [LIST Sales Tax Codes] ON Customers.[Tax Code 1] =
    >[LIST Sales Tax Codes].[Tax Code ID]
    >
    >
    >
    >I don't see anything wrong.



  5. #5
    vingo Guest

    Re: sql error message...please help


    "Heather Boyles" <hboyles@pdan.com> wrote:
    >
    >I am getting an error stating that I am missing an operator with the following
    >sql:
    >
    >SELECT Customers.[Customer Name], [LIST Sales Tax Codes].[Tax Code],
    >[LIST Payment Terms].[Terms Name]
    >FROM Customers LEFT OUTER JOIN
    > [LIST Payment Terms] ON Customers.[Terms ID] = [LIST
    >Payment Terms].[Terms ID] LEFT OUTER JOIN
    > [LIST Sales Tax Codes] ON Customers.[Tax Code 1] =
    >[LIST Sales Tax Codes].[Tax Code ID]


    Try this:

    SELECT Customers.[Customer Name], [LIST Sales Tax Codes].[Tax Code],
    [LIST Payment Terms].[Terms Name]
    FROM ( Customers LEFT OUTER JOIN
    [LIST Payment Terms] ON Customers.[Terms ID] = [LIST
    Payment Terms].[Terms ID]) LEFT OUTER JOIN
    [LIST Sales Tax Codes] ON Customers.[Tax Code 1] =
    [LIST Sales Tax Codes].[Tax Code ID]

    Attend the: "()" must put between two JOIN .





Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center