Combining 3 tables

[dreamer]

I've got three different tables.

Table one is the main table wich contains about 65 000 records.
Table two contains records that are to be excluded from table one.
Table three contains records that will do two things. 1. If the same record is represented in table one it will be replaced by the one in table three. 2. If a record in table three isn't reprecented in table one it will be included in the result.

The database contains names and each name has an unique idnumber.

Did I explain things good enough? 🙂

The best thing would be if this could be done in one query.
So, can anyone help me out here?

[Sxooter]

What Database program?

[Sxooter]

To grab everything in one table EXCEPT for rows duplicated in another table, use except.

select from table1 except (select from table2);

You can use this in a subselect with a single field. you can also use not in with a subselect like

select * from table1 where id not in (select id from table2)

but not in is usually slower than except.