You can do exactly what you describe. We take the CONTACT table and find the row identified by the first ID. Then we combine this with the row having the second ID. We need a join for that. Since the other row is in the same table, we just have to join with table CONTACT. (That results in a so-called self-join.) Then we apply your filter criteria, i.e. the values of all other columns must match.
Code:
SELECT 'true', t1.row_id, t2.row_id
FROM contact AS t1, contact AS t2
WHERE t1.row_id = '1-urfye' AND
t2.row_id = '1-iyrwh' AND
t1.fst_nam = t2.fst_name AND
t1.last_name = t2.last_name AND
t1.addr = t2.addr
Note: you need to enhance the predicates if you may have NULLs in any of the column. NULL is not a value and, therefore, cannot be compared to any other value and NULL = 'abc' is "unknown", which evaluates to "false" in a WHERE clause of a query.
dBforums
>
How to compare two records based on two different ids in a table
12-08-09, 01:39
Linear Mode
