Multiple joins in an Excel Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating reporting queries on a workbook that has multiple tabs as tables. The primary key is a comination of 3 data elements that is present on each of the separate tabs/tables. The qureies seem to work fine with just two joins creating the complete primary key. However, when I add the third join, the query gives up and returns nothing.

Any assistance with this would be greatly appreciated.
 
If you post both SQL statements there might be a chance I could help you.

RBS


Karen S said:
I'm creating reporting queries on a workbook that has multiple tabs as
Click to expand...
tables. The primary key is a comination of 3 data elements that is present
on each of the separate tabs/tables. The qureies seem to work fine with
just two joins creating the complete primary key. However, when I add the
third join, the query gives up and returns nothing.
 
RB-

Thank you for your response and possible help.

When you say "both" SQL statements, are you talking about the SQL statements for the two joins that work? Would all three of the join statements be better? If it's not the join statements, please let me knwo to which SQL statements you refer.

Let me know and I can get these for you.

Thank you, again
 
Just post the whole lot.

RBS


Karen S said:
RB-

Thank you for your response and possible help.

When you say "both" SQL statements, are you talking about the SQL
Click to expand...
statements for the two joins that work? Would all three of the join
statements be better? If it's not the join statements, please let me knwo
to which SQL statements you refer.
 
RBS -

Thank you for your help. I've solved the 3 joins issue. It appears to have been a data formatting issue that does confuse me. I am going to submit a new question regarding cell formats and Query.

Again, thnak you.

Karen S

----- RB Smissaert wrote: -----

Just post the whole lot.

RBS


Karen S said:
RB-
Click to expand...
statements for the two joins that work? Would all three of the join
statements be better? If it's not the join statements, please let me knwo
to which SQL statements you refer.
 
Karen,

What help?

RBS

Karen S said:
RBS -

Thank you for your help. I've solved the 3 joins issue. It appears to
Click to expand...
have been a data formatting issue that does confuse me. I am going to
submit a new question regarding cell formats and Query.
 
Back
Top