Problems with two tables cont...

[James]

Hello I think this is where the problem lies as I have
more fields in one table than I do another. Yet I need all
of the fields to runin the query as I need to be able to
display all the results.

Many Thanks

James

 

[Michel Walsh]

Hi,


Use the table with the largest number of fields first, "fill" the second
select with Null:


SELECT f1, f2, f3, f4, clientID
FROM table1

UNION ALL

SELECT g1, g2, NULL, NULL, clientID
FROM table2


Hoping it may help,
Vanderghast, Access MVP

 

[James]

Hello,

Still it does not do as I ask do all the fields have to be
exactly the same? If Yes then is there another way as this
seems to think that the forename is something like JOE
BLOGGS and the Surname is OFFERTON.....

If they dont need to be excatly the same is there a way a
simple way of making this query work?

Cheers

James

 

[James]

Would you like me to send you a copy of the database would
this help any?

Many Thanks

James