Re: need help with cross referenced tables

[Noober Bad]

you mean ,

Insert into Table A (id,category)
select id , category from Table B
left join Table A on A.id = B.id where A.id = null

One more thing , when should i delete the values in Table B as it is temporary table