How To Perfrom Query on Two Tables

[jsmurthy]

Hello All,

    I need to insert into mm_tagrules table from mm_tag table, in the
following way. I am using mysql 4.0.12 version. But Mysql is not supporting
  subqueries. Can any one help mysql query for the following query.

insert into mm_tagrules
 select ID, 'NIL', 'D' from mm_Tag where mm_Tag.ID not in (select Tagid from
mm_tagrules)

Thanks in Advance
 Regards
 J.S.Murthy