PearlGI
Registered User.
- Local time
- Today, 20:54
- Joined
- Aug 30, 2001
- Messages
- 125
Can anyone think of a reason why the following is happening?
I have a Union query which runs off 2 Select queries, this works.
I then have a Select query that runs from the Union query and another Select query, this also works.
This Select query is then used with other Select queries to create another Select query, this also works.
Now here's the problem:
Whenever I try to use this final Select query (even with just a simple SELECT * FROM {select query} ), I get this error message.
'The number of columns in the two selected tables or queries of a union query don't match.'
Why do I now get an apparent error with the Union so far down the line from the point it was created.
Any help, no matter how small, would be greatly appreciated.
[This message has been edited by PearlGI (edited 09-26-2001).]
I have a Union query which runs off 2 Select queries, this works.
I then have a Select query that runs from the Union query and another Select query, this also works.
This Select query is then used with other Select queries to create another Select query, this also works.
Now here's the problem:
Whenever I try to use this final Select query (even with just a simple SELECT * FROM {select query} ), I get this error message.
'The number of columns in the two selected tables or queries of a union query don't match.'
Why do I now get an apparent error with the Union so far down the line from the point it was created.
Any help, no matter how small, would be greatly appreciated.
[This message has been edited by PearlGI (edited 09-26-2001).]