Apr 07, 2009 10:48 AM|hayashiryo|LINK
Hi All. I have to create a view which I'm not sure how I can formulate.
Refer to the 3 tables below
Each employee can create a product record in the ProductTable
Each product is only linked to 1 employee
Each product can be linked up to 5 images in the ProductImageTable
EmployeeTable 1 - many ProductTable
ProductTable 1 - many ProductImageTable
Now, the view I'm trying to create is this (I reduce the columns for simplicity sake)
EmpID | EmpName | ProductID | ProductName |
Image1URL | Image2URL | Image3URL | Image4URL |
The Image*URL columns are from the ProductImageTable. I am able to link EmpTable and ProductTable. But I"m having difficulty trying to link each individual image to the view.
Also if a product has only 4 images, the Image5URL should be empty string
Please help! Thanks