I need to get records where it satisfy condition from table 1 and table2. For example...<BR>select Company from table1 where Company='MyCompanyName'<BR>AND<BR>select Company from table2 where Field='Yes'<BR><BR>How to combine this 2 up?<BR>Please note that it is not UNION. The COmpany exist in table1 must exist in table2. More like an itersection. Thank You.