[Resolved] SELECT from one table INSERT into another

[spstieng]

Hi,

It's been a while since I did SQL.

Could someone please tell me how I selected info from one table and inserted into another?

In Oracle it would probably be something like:

INSERT INTO Callinglist
VALUES org.orgID
WHERE (
SELECT orgID FROM Organization AS org
LIMIT 10)

How do I do this in MySQL?

[eoghain]

Same way, just get the syntax correct:

INSERT INTO myTable (field1, field2, field3)
SELECT name, address, phone
  FROM myOtherTable;

[spstieng]

I'll give it a go!