GREAT! thanks, however, what if the situation was where the table i wanted to delete from was in a separate directory, how would i reference that using the SQL notation
I am making a delete query that i want to only delete certain fieds (more explained below)
Table1
OneID ¦ Data
1 ¦ 3
2 ¦ 5
Table2
OneID ¦ Random
1 ¦ 25
2 ¦ 29
i want to delete all records in Table2 where Data in Table1 is 3
One other thing...
