var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: New to SQL, but Learning, Query Help
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?
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?