I'm having some trouble with this join.
ausuitability.suitabilityId is a list 1-5 with a description call suittype.
The 2nd last left join brings that table into the main table and has worked fine until I need to display the SuitType rather than the suitabilitId.
When I add the last Left Join it errors.
How would i display the suittype correctly.
So far $suittype only display the description for the suitabilityFoil.
Code: Select all
SELECT * , aupapercategory.paperCategory FROM ausapapersummary
LEFT JOIN aupapercategory ON ausapapersummary.paperCategoryId = aupapercategory.papercategoryId
LEFT JOIN austock ON ausapapersummary.stockId = austock.StockId
LEFT JOIN auadhesive ON ausapapersummary.adhesiveId = auadhesive.adhesiveId
LEFT JOIN auliner ON ausapapersummary.linerId = auliner.linerId
LEFT JOIN ausupplier ON ausapapersummary.supplierId = ausupplier.supplierId
[b]LEFT JOIN ausuitability ON ausapapersummary.suitabilityFoil = ausuitability.suitabilityId[/b]
LEFT JOIN ausuitability ON ausapapersummary.suitabilityLabel = ausuitability.suitabilityId
WHERE summaryId = 210TIA, Will