SQL Query trouble in MS Access 2003

[unixkid]

Hi,

Im writing a query which will delete the rows of one table where its contents in two of it fields matches two contents of another tables fields. The code I have thus far is shown below:

DELETE *
FROM TABLE1
WHERE DocName= (SELECT DocName FROM TABLE2) AND GroupName = (SELECT GroupName FROM TABLE2);

It just doesn't do anything! I changed the DELETE to a SELECT to see if anything was selected and that didn't even work! And yes I am 100% the data was present in both tables to meet the criteria stated!

All help would be much appreciated,

Regards,

unixkid

 

[jdraw]

Can you show us your table structures?

For SQL help
Data manipulation here
http://msdn.microsoft.com/en-us/library/aa140011(v=office.10).aspx#acfundsql_dml

and here

http://www.techonthenet.com/sql/delete.php