Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    3

    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?

    Dennis

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •