Inserting Data using Insert and Select Query

Question

0.00/5 (No votes)

See more:

Hello all..

I am having a problem with sql.

SQL

INSERT INTO Customers (ContactName, CustomerName, Country) Values  ('Islamabad',
SELECT SupplierName, Country FROM Suppliers);

I want to insert contactname manually and and want to insert SupplierName and Country from the Suppliers table in Customer table.

I am getting Syntax Error Near Select.

Posted 9-Jan-14 22:56pm

codegeekalpha

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sibasisjena · Accepted Answer · 2014-01-09T23:03:00

Solution 1

We usually do insert like the bellow query. Do accordingly

SQL

INSERT INTO Customers (ContactName, CustomerName, Country) 
SELECT 'Islamabad',SupplierName, Country FROM Suppliers

Posted 9-Jan-14 23:03pm

Sibasisjena

Updated 9-Jan-14 23:04pm

v2

Comments

hypermellow 10-Jan-14 5:06am

You beat me to a great answer, have 5!

Sibasisjena 10-Jan-14 5:09am

Thank you very much :)

hypermellow · Accepted Answer · 2014-01-09T23:04:00

Solution 2

Try something like this ...

SQL

INSERT INTO Customers (ContactName, CustomerName, Country)
SELECT 'Islamabad', SupplierName, Country FROM Suppliers

Posted 9-Jan-14 23:04pm

hypermellow

Inserting Data using Insert and Select Query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Inserting Data using Insert and Select Query

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us