2 tables one dataBase

[Michael de Haan]

Hi Ruslan,

May I pick your brain....I think it is a simple problem.

I have designed a dataBase with 2 tables. The tables are related only 
in so far as sharing 2 out of 3 common fields. Querying each table is 
easy, but what I want to do is a combined search of both tables and 
then present the combined data as one result (showing all 3 fields 
where available).

Could you suggest the way Valentina could do this?

Thanks in advance