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.
[url]http://www.helixpoint.com[/url]
[email]davefhelixpoint.com[/email]

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
[email]davefhelixpoint.com[/email]
______________________