Re: problem with join

Bill Todd [TeamB] wrote:

What database are you using?

In standard SQL you enclose an identifier that is a reserved word in
double quotes.

The source database is in MS Access form. I say it that way because it
is created by some routines run in SQL Server, to the best of my
knowledge, as an export format.

I've tried enclosing in double quotes: "State" and in brackets: [State]

No joy so far. But perhaps this is not the real source of the error?

My SQL in a TADODataSet is currently:

select Mbr.CAPID, Mbr.NameLast, Mbr.NameFirst, Mbr.NameMiddle,
Mbr.NameSuffix, MbrAddr.CAPID, MbrAddr.Addr1, MbrAddr.Addr2,
MbrAddr.City,
MbrAddr.[State], MbrAddr.Zip
from Member Mbr, MbrAddresses MbrAddr
LEFT JOIN MbrAddresses on Member.CAPID=MbrAddresses.CAPID


--

Bill
.

Relevant Pages

  • Perl DBI - Select across multiple Database
    ... I want to write a sql where I want to get data from target database and ... Source database on using UNION clause. ... But I dont want to use Oracle's ... I want to write above sql in such a way that I dont have to use ...
    (comp.lang.perl.misc)
  • Re: How do I created a query in Access that points to SQL Server 2000?
    ... I've already migrated the database and data over. ... not quite sure how to add a query in the Access form to point to SQL ... If an .mdb file type you can use SQL Pass Through queries. ...
    (microsoft.public.access.queries)
  • Re: SQL And Access Project Security Question
    ... use the VIEW_METADATA option (see SQL Books Online ... >front-end application to an Access Project connecting to SQL server and have ... >If a user has read only permissions of a table at the ... and I want the user to be able to add/edit records via an Access Form ...
    (microsoft.public.sqlserver.security)
  • Re: Want to Display a Datasheet Based on Adhoc Query (SQL)
    ... > SQL Server 2000, MS Access 2003, using Active Directory. ... Use two SQL tables. ... The Access form. ... > This method is similar to using a pass-through query in an .mdb. ...
    (microsoft.public.access.adp.sqlserver)
  • Access Form Null Checking with Linked SQL / ODBC Table
    ... I have a access form that is connected to linked sql table via odbc. ... database but the ODBC error tha tis returned is not very polite to the ...
    (microsoft.public.access.forms)