C
Cassie
Hi,
I have two tables in access (e.g. t1 and t2). I am trying to delete rows
from t1 where t1.key1 and t1.key2 = t2.key1 and t2.key2. There is not a
column that is unique in either table, rather there is a concatenated primary
key based on the first two columns.
Can someone help me with this? I am trying to do it in SQL rather than
through the query wizard but either way will work.
Thanks!
I have two tables in access (e.g. t1 and t2). I am trying to delete rows
from t1 where t1.key1 and t1.key2 = t2.key1 and t2.key2. There is not a
column that is unique in either table, rather there is a concatenated primary
key based on the first two columns.
Can someone help me with this? I am trying to do it in SQL rather than
through the query wizard but either way will work.
Thanks!