Adding records to a join table using a query

[brharrii]

I have 2 tables that are joined by a many to many table:

tblProductInfo
- ProductID

tblProductLinerMM
- PLProductID (FK to [tblProductInfo].[ProductID])
- PLLinerID (FK to [tblLiner].[LinerID])

tblLiner
- LinerID


I have a range of products that each use 2 liners. An inner liner and an outer liner. I need to add 2 records per product to the tblProductLinerMM table.


For example:
tblProductInfo has the following records:
- 2138557
- 2378954
- 4387657

tblLiner has 2 liners in particular that relate to these products:
- L5475
- L5468

I need to create the following records in tblProductLinerMM preferably with the use of a query :
- 2138557 | L5475
- 2138557 | L5468
- 2378954 | L5475
- 2378954 | L5468
- 4387657 | L5475
- 4387657 | L5468


Does anyone have any idea how I might achieve this?



Thank you

[orange]

INSERT INTO tblProductLinerMM (PLProductId, PLLinerId)
SELECT  ProductId,LinerId
FROM tblLiner ,tblProductInfo ;

Since you want all combinations, you use a Cartesian/Cross Join. There is no condition --no where clause.
http://www.w3resource.com/sql/joins/cross-join.php

[brharrii]

Awesome, thank you, If I needed to add a where condition I assume that I could? or would that change things?

[orange]

In the link I posted

The SQL CROSS JOIN produces a result set which is the number of rows in the first table multiplied by the number of rows in the second table, if no WHERE clause is used along with CROSS JOIN. This kind of result is called as Cartesian Product.

If, WHERE clause is used with CROSS JOIN, it functions like an INNER JOIN.

[brharrii]

ha, or I could just read the excellent documentation you provided to get my answer

Thank you!

[brharrii]

I'm still learning some of the terminology... I don't fully understand the difference or significance of an Inner Join versus a Cross Join. I'll do some homework though. Knowing the terms to use is the hardest part of the battle. Thank you again.