Hi,
join two tables in your select. Might look like
insert into mm_tagrules
select ID, 'NIL', 'D' from mm_Tag
left join mm_tagrules on mm_Tag.ID = mm_tagrules.Tagid
where mm_tagrules.Tagid IS NULL;
Regards,
Thomas Spahni
On Tue, 29 Jul 2003, jsmurthy wrote:
> Hello All,
>
> I need to
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
