Hi,
Maybe someone can help. I'm struggling to find resources to help me join 6 tables through a SQL query to run on an ASP page.
There are five tables which are linked together by one table (tblProduct):
tblPartManufacturer:
Id (PK) / PartManufacturer
tblPartType:
Id (PK) / PartType
tblVehicleManufacturer:
Id (PK) / VehicleManufacturer
tblVehicleModel:
Id (PK) / VehicleModel
tblVehicleType:
Id (PK) / VehicleType
tblProduct:
Id (PK) / PartManufacturerId (FK) / PartTypeId (FK) / VehicleManufacturerId (FK) / VehicleModelId (FK) / VehicleTypeId (FK)
If anyone could help with this, or point me in the right direction I'd be most grateful.
Thanks.
Maybe someone can help. I'm struggling to find resources to help me join 6 tables through a SQL query to run on an ASP page.
There are five tables which are linked together by one table (tblProduct):
tblPartManufacturer:
Id (PK) / PartManufacturer
tblPartType:
Id (PK) / PartType
tblVehicleManufacturer:
Id (PK) / VehicleManufacturer
tblVehicleModel:
Id (PK) / VehicleModel
tblVehicleType:
Id (PK) / VehicleType
tblProduct:
Id (PK) / PartManufacturerId (FK) / PartTypeId (FK) / VehicleManufacturerId (FK) / VehicleModelId (FK) / VehicleTypeId (FK)
If anyone could help with this, or point me in the right direction I'd be most grateful.
Thanks.
Last edited: