Removing the same row from 2 tables.

[yzhang316]

Hi There,

I have 2 tables

Table A:

Name	Age	Gender
David	20	M
Jessica	19	F

Table B:

Name	Age	Gender
Kitty	21	F
Paul	22	M
Jessica	19	F
Michael	20	M
David	20	M

I want to be able to delete info from table A in table B.  Result would look like this

Name	Age	Gender
Kitty	21	F
Paul	22	M
Michael	20	M

How do I achieve this...

Thanks!

[yzhang316 · Accepted solution]

I think I found the solution...it's just a simple join.