help with query

you experts hi all
please help with!!

INSERT INTO suplementos (numdeord,rev)SELECT  distinct (odc.numdeord, odc.rev) FROM odc LEFT JOIN suplementos ON odc.numdeord=suplementos.numdeord and odc.rev=suplementos.rev WHERE suplementos.numdeord IS NULL and suplementos.rev is null"

tsm
ErnestoAsked:
Who is Participating?
 
SharathConnect With a Mentor Data EngineerCommented:
Do you mean this?
INSERT INTO suplementos 
            (numdeord,rev) 
SELECT DISTINCT odc.numdeord,odc.rev 
FROM   odc 
       LEFT JOIN suplementos 
              ON odc.numdeord = suplementos.numdeord 
                 AND odc.rev = suplementos.rev 
WHERE  suplementos.numdeord IS NULL 
       AND suplementos.rev IS NULL 

Open in new window

0
 
Éric MoreauSenior .Net ConsultantCommented:
what is the issue?
0
 
ErnestoAuthor Commented:
tsm!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.