I can't quite figure out why I'm getting the error. The call worked fine until I added the second where clause.
ambiguous column name: nanoProd.name:
SELECT
nanoProd.name AS prodName,
nanoProd.intro AS prodIntro,
nanoProd.prodText AS nanoText,
nanoFiles.fileLoc AS nanoFile
FROM nanoProd
LEFT JOIN nanoRelFiles on nanoFiles.rid = nanoRelFiles.file_id
LEFT JOIN nanoProd on nanoProd.rid = nanoRelFiles.item_id
WHERE nanoRelFiles.scr_type = 'prod' AND nanoRelFiles.fileUse = 'list'
Aucun commentaire:
Enregistrer un commentaire