I have 2 tables.
table1 and table2
I do a select on table1 and join table 2 on id.
I want to check newprice in table1. if it is null, I want to copy oldprice
in table 2 to newprice in table1


David Fetrow
HelixPoint LLC.

Interested in Affordable Email Marketing?
Check out the HelixMailer at [url]http://www.helixpoint.com/helixmailer.asp[/url]
If you are interested in becoming a Reseller of HelixPoint products, contact