Re: Fw: Complex SQL assistance

2002-07-29 Thread Corey Wallis
Jon, This is exactly what was needed. You are correct in that we're using the mysql To: "Gerald Clark" <[EMAIL PROTECTED]>; "Corey Wallis" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, July 27, 2002 8:16 AM Subject: RE: Fw: Complex S

Fw: Complex SQL assistance

2002-07-27 Thread Corey Wallis
Peoples, I'm currently trying to work out if this is possible by SQL. I have the need to use SQL and only SQL to achieve the following. If a record exists and meets a certain criteria (i.e. field X = '1234') then update the record. If the record doesn't exist then insert it. For reasons too com