Is this possible with sql?

Posted by Andrew on Stack Overflow See other posts from Stack Overflow or by Andrew
Published on 2010-04-14T14:22:50Z Indexed on 2010/04/14 14:33 UTC
Read the original article Hit count: 166

Filed under:
|

Is it possible to do something like this:

INSERT INTO table(col1, col2) VALUES(something_from_another_table, value);

With something_from_another_table being a SQL command? Like, is there something I can do that's equivelant to:

INSERT INTO table(col1, col2) VALUES((SELECT value FROM table2 WHERE id = 3), value);

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql