Possible Limitation?

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

Guest

I have a multiple Sub-Queries (SQ) that I use to build a master Query's
information.

So Query1 has an ID field that all the SQ's are based off of. I think I
might have a limitation, but am not sure.

I am able to join 5 SQ's to the ID field on my main Reference Table. If I
add another SQ join to that ID field, the query fails? Any ideas here. I am
able to remove one of the SQ joins and add one of the failing one, without it
working.

Please advise!

Thank you in advance!

Blaze
 
Hi Blaze,
Just a quick thought - have you set the time-out to 0 in all of the
subqueries and master query? Also, I wasn't clear - when you switched sub
queries, did the failing one work or still fail? If it still failed, it
sounds like that sub query has a problem.
 
Well, I did look at the ODBC timeout and moved it to 90 instead of the
default 60. That didn't fix the issue. I'm not sure how I change the
sub-query timeout, but I'm sure they are set to the default as I didn't
change it. If you let me know how to check, I will.
The query runs, just no data returns. I have 6 SQ's that pull up charge
information, which are columns under in the Table ID that I'm joining. The
SQ's do the same thing, just reference different Charges 1-6. If you run the
SQ, individually, they all run. Once you get 5 of them the query runs
without error and query returns nothing.

Hope this explains more. I would post the SQL syntax, but it's like 7 pages
long:)

Blaze
 
Hi Blaze,

Okay, so the query runs, but returns no results. Forget the timeout
thing. This usually happens when the column that all the subqueries and
table are joined on, has no value that is found in all of them. Is this the
case? You may be able to change the join type, right click on the join line
and you should get join options. Try everything from main table and only
those from subqueries where fields are equal.
 
Back
Top