Search results

He is using this query on 2 different sets of tables. On the first set is a NULL value, on the second set there isn't a NULL value. Hmm...

Ok, thank you very much. I'm going to try this ASAP.

What is the best way to check this? Thank you very much

Not that I am aware of, sorry. TABLE [table1] UNION ALL TALBE [table2] SELECT * FROM table1 UNIOAN ALL SELECT * FROM table2 Are those 2 query's the same?

Yes, they are. (Also, worked before SP3, so the query must be right?)

Re: Query too complex - Access 2007 (SP3) But it worked in previous versions of Access (without SP3). TABLE [table1] UNION ALL TALBE [table2] < Doesn't work. TABLE [table1] UNION TALBE [table2] < Works. SELECT * FROM table1 UNIOAN ALL SELECT * FROM table2 < Works, but I doesn't know this...

A client is getting this error when he is trying to execute this query: TABLE [table1] UNION ALL TALBE [table2] I'm not sure if this query is right. If we use UNION (without all) the query works just fine. SELECT * FROM table1 UNIOAN ALL SELECT * FROM table2 the same as the previous querty...