Solved

help with query

Posted on 2013-06-07
3
277 Views
Last Modified: 2013-06-07
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
0
Comment
Question by:edo60
3 Comments
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39229853
what is the issue?
0
 
LVL 40

Accepted Solution

by:
Sharath earned 500 total points
ID: 39229861
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
 

Author Closing Comment

by:edo60
ID: 39229866
tsm!!!
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question