question

libertyhunter avatar image
libertyhunter asked

INSERT INTO NOT IN

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

insertnot-in
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RickD avatar image
RickD answered

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            
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Madhivanan avatar image
Madhivanan answered

Can you post in English?

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.