>>For example I have 4 same type tables which contains:
>>1 table 1995 year's invoices
>>2 table 1996 year's invoices
>>3 table 1997 year's invoices
>>4 table 1998 year's invoices
>>
>>And for example user wants to know some information from 96-97 years.
>>How connect those tables into one to have virtually one table, not 4?
>>
>>Can I use views? Is there easiest way to do it?
>>
>>Giedrius
>
>Select * From table96 Where ... Into Cursor tmp ;
>Union Select * From table97 Where ...
I know it... But I thought that there is some easer way to do it. Something like views or ...
Giedrius