combination table

[iraidotel@yahoo.com]

Dear All,
I use MS Access 2003, there are two tables that I want to join in the query depth_from and his depth_to be sequentially
Exel example in the attached file
please help her
greetings, Ira

 

[plog]

The answer to this specific issue is to use a UNION query: http://www.w3schools.com/sql/sql_union.asp

However, I think you have bigger fish to fry. Why do you have 2 tables with the exact same structure? That goes against normalization and is going to cause more issues down the line.