sql query reqest

S

subs

Ocity Dcity equipmt carrier price note
chicago Atlanta c dash 1210 most current
chicago Atlanta c dash 2310
chicago atlanta d dash 1231
houston chicago d dash 5490 most current

I have a table like the above one. i need to delete the rows where
ocity,dcity,equipmt and carrier fields are equal but
the note field does not have the value "most current"

for example i will delete the 2nd row and keep the rest in the table
how to do this by a SQL query
pls help
 
J

John Spencer

Answered in your earlier posting. We are all volunteers and are not online
constantly. It is a good idea to give us at least 24 hours to respond.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 

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

delete certain rows 1
Query or a form required 9
Query to add rows with a criteria 4
Query needed 3
complex sorting query 3
Query combining the tables 15
Tranportation query - interesting one 1
deleting duplicates but with a condition 5

Top