>>>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 ...
IMHO, it's much easier than view ...
Edward Pikman
Independent Consultant