How to create a contains method on two different table with multiple column comparison using sql in vb6
===

I have (Table1.column1 and Table1.column2) and another (Table2.column1 and Table2.column2) in my db and i wanna get result where (Table1.column1 and Table1.column2) values not found in (Table2.column1 and Table2.column2)?

    Table1                          Table2
    ------------------------        ------------------------
     sid   sname    sclass            rid  rname    rclass
    ------------------------        ------------------------
    | 1 | glass  | a class |        | 1 | glass  | b class |
    | 2 | glass  | c class |        | 2 | glass  | c class |
    | 3 | ice    | a class |        | 3 | ice    | b class |
    | 4 | ice    | b class |        | 4 | ice    | c class |
    | 5 | fridge | a class |        | 5 | fridge | a class |
    | 5 | fridge | b class |        | 5 | fridge | c class |
    ------------------------        ------------------------

result should be :

    Result Table
    ------------------------
     sid   sname    sclass 
    ------------------------
    | 1 | glass  | a class |
    | 3 | ice    | a class |
    | 5 | fridge | b class |
    ------------------------

as i mentioned up there, this is similar to contains method but im going to use this sql string in vb6..

there are  a,b,c classes and every item such as (glass, fridge.. etc.) can contain any of these a,b,c classes so any combination of table2 should not exist in my result..

I want to do it with sql query which is like:

    "SELECT * FROM area1 AS table1,(SELECT * FROM area2 WHERE blablabla..) AS table2 WHERE table1.SNAME = table2.RNAME AND table1.sclass <> table2.rclass"