AAA VE BBB İSİMLİ 2 TABLOM VAR
BBB NIN İÇİNDE OLUP TA AAA NIN İÇİNDE OLMAYAN KAYITLARI AAA TABLOSUNA EKLEMEK İSTİYORUM. NOT IN KOMUTUNU TAM OLARAK KULLANAMIYORUM.
LÜTFEN YARDIM
My Turkish doesn't extend very far, but I am half-guessing that you are trying to insert into one of the tables AAA or BBB where the values are NOT IN the other table?!?
Something like:
Insert into AAA
select <fieldlist>
from table BBB
left join AAA
on AAA.<joinfield> = BBB.<joinfield>
where AAA.<joinfield> is null
No one has followed this question yet.