I forgot to mention one major item. I am assuming you are using the editor when working on this, right? Well you need to be connected to the ToadSampleDatabase. Make that the current connection and then execute.
Debbie
Yes, I'm using the editor, although the initial query is stored in a tsm file - I think because I imported my exist SQL that I had written just for the Oracle piece in, and then went to QB to make my Join.
I didn't know that I needed to be connected to the Toad Sample DB - I am now, and now I'm getting a new error - but it seems like I might be getting closer, as this is a syntax one:
Error:4/30/2010 0:00:00.062: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(CVAR(IDW.ACCTCORP) = CVAR(IDC.ACCTCORP)) AND (CVAR(IDW.HOUSE) = CVAR(IDC.HOUSE)) AND (CVAR(IDW.CUST) = CVAR(IDC.CUST))
(wrapping is due to editor on here - in the TDA editor it's on one line).
Do I have to be connected to the ToadSampleDB because it's actually Access that's executing the HG query?
Debbie Peabody wrote:
I forgot to mention one major item. I am assuming you are using the editor when working on this, right? Well you need to be connected to the ToadSampleDatabase. Make that the current connection and then execute.
Debbie
Yes, you need to be connected to the Sample Database because Access is doing the executing.
The missing operator should be pretty simple to find.
I would think it would, yes, but I really don't see the issue. I rarely use access for anything other than simplistic joins, and never more than a two-table join at that.
To me, the JOIN syntax looks fine, compared to what I'm used to seeing in Access - ie.:
INNER JOIN table1 ON (table1.c = table2.c) AND (table1.d = table2.d) AND (table1.e = table2.e)
The CVAR part was generated automatically, and I'm honestly not sure what the purpose is - I took it out and I'm still getting the same Syntax error. I've replaced all the ANDs with ON - same error. I've replaced ANDs with AND ON - same error. I've got a valid relational operator between the two fields, and according to Access's help, I only need to have "AND" between each piece of the JOIN.
I'm sorry if it's obvious; I just don't what the issue is.
Debbie Peabody wrote:
Yes, you need to be connected to the Sample Database because Access is doing the executing.
The missing operator should be pretty simple to find.
Send me a full screenshot of the connection, editor and error. Cut and paste SQL and text of error. I’ll take a look.
Debbie