I am using MS access table . Any example on this?
I am using MS access table . Any example on this?
So you have two tables,
tbl1 tbl 2
1 ---- 1
2 ---- 3
3 ---- 4
4 ---- 5
and you want to delete the record for "3" in your first table? If so, you would outer join the two tables, i believe that would be a left join from 1 to 2. then
DELETE *
FROM tblname
WHERE tbl2.fieldname Is Null.
obviously thats pseudo-code but you get the picture.