delete row where only related to one other row
Say I have two tables:
table_a
--
a_id (primary key)
b_id
table_b
--
b_id (primary key)
name
there is a one to many mapping between rows in table b and rows in
table a.
Say I had an Id of a row in table a an (a_id, say 5). Now, what
Say I have two tables:
table_a
--
a_id (primary key)
b_id
table_b
--
b_id (primary key)
name
there is a one to many mapping between rows in table b and rows in
table a.
Say I had an Id of a row in table a an (a_id, say 5). Now, what I
want to do is delete the row in table_a (ea