How can i select leftJoin table info in different field?
Table Food:
id name category other-category
1 Apple 1 2
Table Category:
id name
1 Plantae
2 Rosids
->leftJoin('Category', 'Food.category', '=', 'Category.id')
->leftJoin('Category', 'Food.other-category', '=', 'Category.id')
But i got error Not unique table/alias:
Here i want is Food.name, category.name, other-category.name
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire