很菜的问题！求高手帮忙！！！立刻给分

Question

insert into av_accounts_main
           (owner_id, bank_id, total, deposit, salary, other, payout, balance, store_flag)
           select b.user_id, '000000000000', 0, 0,b.achievement26,0,0,0,'Y'
           from av_achievement_rec_total b left join av_accounts_main a
      on a.owner_id =b.user_id where  b.user_cat = 'Y' and  b.achievement26 > 0 and a.owner_id is null

Answer 1

--tryinsert into av_accounts_main
           (owner_id, bank_id, total, deposit, salary, other, payout, balance, store_flag)
           select user_id, '000000000000', 0, 0,achievement26,0,0,0,'Y
           from av_achievement_rec_total where user_id not in (select owner_id from av_accounts_main) and user_cat = 'Y' and achievement26 > 0

Answer 2

xixi 我先拿回去看看  如果可以  立刻给分   谢谢了