SubSelects to JOINS

[querry]

Hi all,

I am trying to write a SQL Querry that inserts rows into a table by selecting values from another tables.

General Syntax for inserting values into a table from one or more tables is as follows

INSERT INTO <table_name> | <view_name> [ ( <column_list> ) ] SELECT <column_list>
| <literal_value> FROM <table_name> | <view_name>

My querry looks something like this...

INSERT INTO <table_name> [ ( <column1, column2, column3, ...> ) ]
SELECT <column1, column2, (SELECT <column1> FROM <table_name> )>
FROM <table_name>

this works for me...

But my question is ... Can I use joins instead of these SubSelects?

If yes, please provide me with some ex code.

Many thanks.

[brutusram]

Do you need to insert multiple table information into this table? If you do then the inner join can be used in the Insert statement like this below:

INSERT 
INTO tbl_InsertMe 
(myCol1, myCol2, yourCol1, yourCol2)
SELECT 
tbl1.myCol1,
tbl1.myCol2,
tbl2.yourCol1,
tbl2.yourCol2
FROM
tbl1
INNER JOIN
tbl2
ON
tbl1.PrimaryKey=tbl2.ForeignKey
---You can place your where statement here if you need one.
 

I tried to make that clear. If you need anymore help with this let me know.

BrutusRam

Hi all,

I am trying to write a SQL Querry that inserts rows into a table by selecting values from another tables.

General Syntax for inserting values into a table from one or more tables is as follows

INSERT INTO <table_name> | <view_name> [ ( <column_list> ) ] SELECT <column_list>
| <literal_value> FROM <table_name> | <view_name>

My querry looks something like this...

INSERT INTO <table_name> [ ( <column1, column2, column3, ...> ) ]
SELECT <column1, column2, (SELECT <column1> FROM <table_name> )>
FROM <table_name>

this works for me...

But my question is ... Can I use joins instead of these SubSelects?

If yes, please provide me with some ex code.

Many thanks.

[querry]

Its a bit late, but thank you very much.