Newbie - combining two identical tables
Posted on 2005-05-17
I have manually separated a large database (well large to me) into two tables, one DRAWCURR and DRAWOLD
for current drawings and old drawings
Most of the time the users just need to access the DRAWCURR, but sometimes I might want to provide a VIEW? or some recordset (called DRAWALL?) which combines the two identical tables but I am at a loss on how to do this.
I suspect this is easy SQL.
I am not sure if I want a join or what to do
I have looked in the syntax guides but I am just getting confused as the tables are not really related