Still new at SQL

Results 1 to 2 of 2

Thread: Still new at SQL

  1. #1
    KSeale Guest

    Default Still new at SQL

    Can you do two queries back to back? For instance, could I run a query that joins two tables where value1 = value2, and then use the results of that query to do an update query?

  2. #2
    Join Date
    Dec 1969

    Default RE: Still new at SQL

    In SQL Server, generally it is not possible to update the results of a join since it creates ambiguities in the key arrangement. Updating a view is possible but not if it contains a join. <BR><BR>You could describe what are the criteria for the update and prehaps someone could furnish you with a SQL statement.

Posting Permissions

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