macromedia.coldfusion.database_access
[Top] [All Lists]

Access Query

Subject: Access Query
From: "semi star gazer" <webforumsuser@xxxxxxxxxxxxxx>
Date: Thu, 21 Feb 2008 19:09:27 +0000 (UTC)
Newsgroups: macromedia.coldfusion.database_access

Hi, I am trying to write a delete query in Access, but not sure where to start.

 I have two tables, request and week1, that share a field, "id".

 I want to keep all of the records in request, but delete any records in week1 
that do not have an id that is also present in request.

 Please help! Thanks.


<Prev in Thread] Current Thread [Next in Thread>