>>>How know which records are (aren't) in another table?
>>>Using SELECT query?
>>>And when you need more than one criteria?
>>
>>First, let me make sure that I understood your question correctly. I assume that you have two almost identical tables and you want to retrieve records from table1 which are missed in table2. If it's really so, you run following query:
>>Select * from Table1 ;
>>Where Table1.Primarykey NOT IN (Select PrimaryKey From Table2)
>Yes, I understand your point.
>But, what I have to do, when I haven't absolutely identical tables?
>And what is worse I haven't one Key.
>I must seek in one table from another one by 3 or more related keys.
>
>And query:
>Select * from Table1 ;
>where Table1.Key1+Table1.Key2+Table1.Key3 NOT IN ;
>(Select Table2.Key1+Table2.Key2+Table2.Key3 From Table2)
>is notsatisfactory for me.
>Do you understand me?
Not exactly. It doesn't matter how many fields constitute primary key. And it doesn't matter how identical tables are. The only thing you should care is primary key which allow you to bring missing (or all minus missing, etc) records form one of the table. Maybe, you could give an example what records you really expect to retrieve.
Edward Pikman
Independent Consultant