How do I update a table when condition is met in 2 tables like below.
update c set c.unitcost = '1249.91' where c.id = '622' AND ( x.charged = '0000-00-00' OR x.charged IS NULL )
something like this, i think:
update c, x set c.unitcost = '1249.91' where c.id = '622' AND x.field = c.field AND ( x.charged = '0000-00-00' OR x.charged IS NULL )
