qmqmqm
March 26th, 2009, 08:50 PM
I have some tables in a database. The fields of each table are like this:
Table 1: id, value
Table 2: table1_id, value
I wish to perform kind of a "clean-up" to the datebase: delete all entries in Table 1 if it is not in table 2.
Does anyone know the syntax to do this?
Thanks,
Tom
Table 1: id, value
Table 2: table1_id, value
I wish to perform kind of a "clean-up" to the datebase: delete all entries in Table 1 if it is not in table 2.
Does anyone know the syntax to do this?
Thanks,
Tom