Re: Accessing remote data using "IN" clause in query with INNER JOINs.

I don't believe you can use multiple IN clauses.

Create Linked Tables that point to your external tables, and use the linked
tables in your queries.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Leigh Hall" <leigh.hall@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:6D77F6D5-22C3-4A77-9D97-B6A6A9EB29FE@xxxxxxxxxxxxxxxx
Hi,

I am trying to access back end data from a front end database. In the
backend, I can construct my query without a problem, but when I move it
into
the front end, I obviously need to add some "IN 'c:\...\...\db.mdb"
statements. I am having trouble doing this because the query has a couple
of
INNER JOINs.

Here is my original SQL ( that works in the BE):

SELECT tblTeam.UserID, tblMain.*
FROM tblTeam INNER JOIN (tblCoreData INNER JOIN tblMain ON
tblCoreData.UserName = tblMain.UserID) ON tblTeam.Team = tblCoreData.Team
WHERE (((tblTeam.UserID)="User.Name"));

Here is my modified SQL (that I cannot get to work in my FE):

SELECT tblTeam.UserID, tblMain.* FROM tblTeam IN
'C:\...\...\...\...\Database_BE.mdb' INNER JOIN (tblCoreData IN
'C:\...\...\...\...\Database_BE.mdb' INNER JOIN tblMain IN
'C:\...\...\...\...\Database_BE.mdb' ON tblCoreData.UserName =
tblMain.UserID) ON tblTeam.Team = tblCoreData.Team WHERE
(((tblTeam.UserID)="User.Name"));


I get an error stating that there is a syntax error in my FROM clause.

Any help would be appreciated. I constructed the first query in a normal
Access query, but I will be utilising it in VBA.

Thanks,
Leigh H



--
remove the capital letters from my email address to contact me.


.

Relevant Pages

  • Re: Accessing remote data using "IN" clause in query with INNER JO
    ... Multiple IN clauses don't seem possible, but it seems possible to get the ... Doug Steele, Microsoft Access MVP ... I am having trouble doing this because the query has a couple ... FROM tblTeam INNER JOIN (tblCoreData INNER JOIN tblMain ON ...
    (microsoft.public.access.externaldata)
  • Re: Accessing remote data using "IN" clause in query with INNER JO
    ... remove the capital letters from my email address to contact me. ... I am having trouble doing this because the query has a couple ... FROM tblTeam INNER JOIN (tblCoreData INNER JOIN tblMain ON ... I get an error stating that there is a syntax error in my FROM clause. ...
    (microsoft.public.access.externaldata)
  • Re: 10053 Interpretation....
    ... I have a query against a large table which contains 2 ... If I query this table with one of the WHERE clauses as such: ... SINGLE TABLE ACCESS PATH ... table io scan cost 75638 ...
    (comp.databases.oracle.server)
  • 10053 Interpretation....
    ... I have a query against a large table which contains 2 ... If I query this table with one of the WHERE clauses as such: ... SINGLE TABLE ACCESS PATH ... table io scan cost 75638 ...
    (comp.databases.oracle.server)
  • Re: how to get unique resultset
    ... > If you have more than one row in tblMain that meets the criteria then ... > query results using the query I gave you. ... > more associated rows exist in the subquery, and display that row once ... > tblKeyphrases in the syntax I gave you, but that is exactly the point. ...
    (microsoft.public.access.queries)