I have two tables that joined together by a third table to allow a many to many relationship. the tables are as follows:
tblProductInfo --> tblProductLinerMM <---tblLiner
Since each product can use multiple liners, the join table manages the relationship allowing for multiple liners to be associated with multiple products. This is all setup and working fine.
The challenge I have now is that I want to create a query that will return a single row per product and have each liner be an additional field. From what I can tell, I need to use a union query to achieve this, but when I try to run my query I get the error message:
"The Number of columns in the two selected tables or queries of a union query do not match."
Can anyone tell what I'm doing wrong?
Code:
SELECT ProductNumber, ProductDesc1
FROM tblProductInfo
UNION ALL
SELECT PLLinerID
FROM tblProductLinerMM