jeudi 4 juin 2015

Why am I getting an "ambiguous column name" error in SQLite?

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