Query two different tables with one criteria

[jhrs]

Hi my friends, I need to filter two tables with one criteria, e.g. *main* in two tables and get the result

thanks a lot

 

[PHV]

Any chance you could be more specific ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[jhrs]

HI PHV, thanks for your answer
I have to tables of customers with different estructure, and I have to filter in both with the same criteria, for example: Like *main* AND *3* and to apply it in both tables at the same time, I hope I war clear

 

[PHV]

Take a look at Union query

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244