Code: Select all
"Select Inventory.PLU_Number,Inventory.Plu_Description,Brands. Brand_Name,Department_Name,Inventory_Prices.Price From Inventory Inner Join Brands On Inventory.Brand_Number = Brands.Brand_Number Inner Join Departments On Inventory.Department_Number = Departments.Department_Number Inner Join Inventory_Prices On Inventory.PLU_Number = Inventory_Prices.PLU_Number" into tQuery
I was looking to use something like this
Code: Select all
Select
Inventory.PLU_Number,
Inventory.Plu_Description,
Brands.Brand_Name,
Department_Name,
Inventory_Prices.Price
From
Inventory Inner Join
Brands
On Inventory.Brand_Number = Brands.Brand_Number Inner Join
Departments
On Inventory.Department_Number =
Departments.Department_Number Inner Join
Inventory_Prices
On Inventory.PLU_Number = Inventory_Prices.PLU_Number
Thank you
J