Complex SQL AnyOne

Results 1 to 3 of 3

Thread: Complex SQL AnyOne

  1. #1
    EggMan Guest

    Default Complex SQL AnyOne

    Can I update a column in one table based on a column in another table. for example, something like :- <BR><BR>update tabelenameA set tablenameA.section = tablenameb.section <BR>where tablenamea.filename = tablenameb.filename<BR><BR>I am basically using the dot notation but don&#039;t know if it works with updates.<BR><BR>Thanks in Advance

  2. #2
    Join Date
    Dec 1969

    Default RE: Complex SQL AnyOne

    there&#039;s an example of it in "save yourself SQL hassles" on<BR><BR>it&#039;s not actually all that complex.<BR><BR><BR>

  3. #3
    EggMan Guest

    Default RE: Complex SQL AnyOne


Posting Permissions

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