I've got two tables. Table A is Fruit, Table B is Vegetables.
Table A
-----------
id|name
1|orange
2|apple
3|grape
4|tomato
Table B
-----------
id|name
5|carrot
6|cucumber
4|tomato
I want to select all the items from table B, that are NOT in table A? What is the best way to accomplish this?
