Solved

delete query syntax in access

Posted on 2013-01-31
2
184 Views
Last Modified: 2013-01-31
I have two tables both with VRR_VehicleID I was hoping to delete the records in TblExporthVinstems that are in table [Upload forcedmatches] I have sql as:

DELETE *
FROM TblExporthVinstems
WHERE NOT EXISTS (SELECT * FROM TblExporthVinstems where TblExporthVinstems.[VRR_VehicleID] = [Upload ForcedMatches].[VRR_VehicleID]);

but when i run it doesnt know [Upload ForcedMatches].[VRR_VehicleID] it sits there waiting for a parameter and not sure why.
ee.PNG
0
Comment
Question by:PeterBaileyUk
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 38838710
I presume it's simply because you have to say = [Upload ForcedMatches] in the frmo
DELETE *
FROM TblExporthVinstems
WHERE NOT EXISTS (SELECT * FROM  [Upload ForcedMatches]  where TblExporthVinstems.[VRR_VehicleID] = [Upload ForcedMatches].[VRR_VehicleID]); 

Open in new window

0
 

Author Closing Comment

by:PeterBaileyUk
ID: 38838754
thank you
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
query question 13 48
MySQL left join performance 4 30
Query Records that don't match 8 32
Access 2010 Query Syntax 5 21
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now