Mysql Join question....been stuck for ages! HELP PLEASE?

Question

i have a join question i have been stuck on for ages....can someone show me how to solve this?

i need to find out a field that has not been included in another table
the two tables are module and activity

there are two fields in module (ID and title) and several in activity, including moduleid which is the same as ID in module table

i need to list the ID of what is missing from the activity table that is listed in the module


thanks

Answer 1

SELECT ID

FROM module

WHERE ID NOT IN

(

SELECT moduleid from activity

)

Answer 2

Try the MSSql forums, a better probability of getting the answer,



http://forums.devshed.com/ms-sql-development-95/

Answer 3

ghu