Problems with two tables cont...

  • Thread starter Thread starter James
  • Start date Start date
J

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
 
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
 
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
 
Would you like me to send you a copy of the database would
this help any?

Many Thanks

James
 
Back
Top