Simple query problem

[zumie]

I'm an IT guy that needs to construct a query that places a 0 in an email field when I get bounceback email and changes the DateModified. What I have gives me a syntax error:

UPDATE [NAMES]
SET EMAIL = 0
WHERE EMAIL
IN(SELECT [Found Address] FROM [MBounce2006-01-24])
and SET DateModified = 01/20/20060
WHERE EMAIL
IN(SELECT [Found Address] FROM [MBounce2006-01-24]);

A little help from the pros?

Zumie



Visualize whorld peas.

 

[smbpalepilsen]

zumie,

UPDATE [NAMES]
SET email = 0,
datemodified = #01/20/2006#
WHERE email IN (SELECT [Found Address]
FROM [MBounce2006-01-24]
WHERE = value_here)

value_here = value to filter the record in your subquery.

I'm assuming you are updating 2 columns from NAMES table and you are limiting your update base on the return values from you subquery.

Please let me know if this wont solve your problem.

Ogie

 

[zumie]

Ogie,

Thanks for the help. This worked:

UPDATE [NAMES]
SET email = 0,
datemodified = #1/20/2006#
WHERE email IN (SELECT [Found Address] FROM [MBounce2006-01-24]);

Thanks again.

Zumie



Visualize whorld peas.