I have two tables,

Table A and B

I need to do a update on table B that has all my data from table A

I need to compare The PartNo colume in B with Field1 from Table B
If they match, I need to set the Price to 0 in Table B.

I have this

Update tableb Set price = 0.0 where PartNo = Field1

But it don't like that cause it don't know where to get field1? How do I say it is in a differant table?

Dennis

Which SQL dialect (DB2, MS-SQL, MySQL, Oracle, other)? What has the instructor covered so far in class? Have there been any examples like this?

-PatP