Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- R. Vince
April 23, 2007, 11:45 pm
rate this thread
YYYY-MM-DD). I have a second table, tableB, which has a field with an int
field which refers to the ID of tableA (or is null). I call this field
I am trying to delete rows in tableA where the date is less than a specified
value AND there is no reference to said row in tableB.
But how to specify this in SQL. I tried :
DELETE FROM tableA WHERE tableA.date <'2007-01-01' and tableB.idA!=
only to get the exception Unknown table 'tableB' in where clause.
Can anyone help me out here? Thanks, R. Vince
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum