Strange Query On Naff Database

[cuttsy]

Someone (dont ask me why) has created a database to hold pupil details in our region and held the data on 2 tables. One table holds info on all the pupils in the region that are members of a certail scheme. Another table is holding slightly different info on all the pupils that are not members of the scheme (the columns are slightly different). There is no link between the tables.

I am going to replace this with a database that makes sense but I need quickly to somehow create a query that uses the information in both tables and shows it in a query as if it was all held in the same table.

I cant think how to do this. When I try I just get sName and sName1 school and school1.

Thanks.

 

[Mile-O]

You need a union query which can't be done in the query design grid - it's straight out SQL.

SELECT Fields
FROM Table 1
UNION
SELECT Fields
FROM Table 2;

The number of fields needs to be identical and the data types of these fields also.

 

[cuttsy]

Thanks

Cheers, i knew there was a way