Rory> I want to write an efficient query that will delete all records
Rory> from one table when they show up in another table (pending
Rory> shipments --> shipped shipments). I can't do it with this:
mysql> DELETE from pending_2 WHERE pending_2.ordno = ordersearch_2.ordno;
Rory> becau
I'm having difficulty doing a LEFT OUTER JOIN, and was hoping someone could
shed a little light on what I'm doing:
Table A has one column, "val", that's an integer. There are 90 records, with
values of "val" from 1-90.
Looks like this:
val
---
1
2
.
.
.
90
Table B is more sparse, with 2 colum
