Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Use Values from Other Tables in UPDATE Statements
How To Use Values from Other Tables in UPDATE Statements? - Oracle DBA FAQ - Understanding SQL DML Statements
✍: FYIcenter.com
If you want to update values in one with values from another table, you can use a subquery in the SET clause. The subquery should return only one row for each row in the update table that matches the WHERE clause. The tutorial exercise below shows a good example:
UPDATE fyi_links SET (notes, created) =
(SELECT last_name, hire_date FROM employees
WHERE employee_id = id)
WHERE id < 110;
3 rows updated.
SELECT * FROM fyi_links WHERE id < 110;
ID URL NOTES COUNTS CREATED
---- ------------------------ --------- ------- ---------
101 http://dev.fyicenter.com Kochhar 999 21-SEP-89
102 http://dba.fyicenter.com De Haan 0 13-JAN-93
103 http://sqa.fyicenter.com Hunold NULL 03-JAN-90
This statement updated 3 rows with values from the employees table.
2007-04-21, 5522👍, 0💬
Popular Posts:
What is the method to customize columns in DataGrid? Use the template column.
Is There Any XSD File to Validate Atom Feed Files? - RSS FAQs - Atom Feed Introduction and File Gene...
How can I execute a PHP script using command line? Just run the PHP CLI (Command Line Interface) pro...
What is the sequence of UML diagrams in project? First let me say some fact about this question, you...
What are secure and non-secure websites? A secure Website uses the Secure Socket Layer (SSL) protoco...