Changing a Unmatched query into a delete query

Y

yellowboy327

Joined
Dec 13, 2007
Messages
1
Reaction score
0
Hi
I have 2 tables that I ran a unmatched query on, now i want to delete the unmatched data from the first query and its giving me issues. here is what I have

DELETE [120707 SAP Contract Extract].[Customer number], [120707 SAP Contract Extract].[Customer Name], [120707 SAP Contract Extract].[Material Number], [120707 SAP Contract Extract].[Material Description], [120707 SAP Contract Extract].Rate, [120707 SAP Contract Extract].Currency, [120707 SAP Contract Extract].[Pricing unit], [120707 SAP Contract Extract].[Unit of measure], [120707 SAP Contract Extract].[Validity start date], [120707 SAP Contract Extract].[Validity end date], [Oracle OKC Final (2)].[Item Number]
FROM [120707 SAP Contract Extract] LEFT JOIN [Oracle OKC Final (2)] ON [120707 SAP Contract Extract].[Material Number] = [Oracle OKC Final (2)].[Item Number]
WHERE ((([Oracle OKC Final (2)].[Item Number]) Is Null));

I continue to get the error message "Specify the table containing the records you want to delete"

Please help
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Available Java, Dot net and SAP SD CRM consultants with us...................... 2
Let me present list of my available const 3
Calculating fields, sum, and breakdown by cust query 1
Move Data into a blank field in a query 10
parsing from a txt file into a table 2
Find and deleting a # sign in a recordset 2
RE: You tried to execute a query that does not include the specified e 0
Query to get a field's name 2

Top