Results 1 to 6 of 6
Thread: Delete query not quite correct
May 18, 2005, 01:52 #1
Delete query not quite correct
hi there i need to delete some values which have dates that are less than today's from a table. The date is in another table so i joined the two tables together and gave a clause
I did this:
DELETE * FROM RMASerial, Sold WHERE RMASerial.SoldID=Sold.SoldID And Sold.Warranty_date<Date();
May 18, 2005, 01:56 #2
FROM RMASerial, Sold
Just remove the * and u find the solution....
May 18, 2005, 01:58 #3
Hi i removed the *
But it still gave me an error:
Specify the table containing the records you want to delete.
May 18, 2005, 02:00 #4
- Join Date
- Jul 2001
- 0 Post(s)
- 0 Thread(s)
Does it throw an Error?
Ignore that! I've always had problems with dates and access. Try using the DATEDIFF function and delete anything that has a return value more than zero.
May 18, 2005, 02:08 #5
can u tell me the error which is coming..
May 18, 2005, 02:25 #6
nvm managed to solve it already
DELETE FROM RMASerial WHERE RMASerial.SoldID IN(SELECT Sold.SoldID FROM Sold WHERE Sold.Warranty_date<Date());