I have two tables
1-products
--------
product_id
product_name
2-product_images
--------------
image_id
product_id
product_image
Now I have multiple images for one product. Means there are multiple records for in product_images table for single product_id.
When I execute this query
$products = Product::join('product_images AS pi', 'pi.product_id', 'products.product_id')
->get();
This results in getting multiple rows for same product due to join. Now how do I handle that in spite of many images for single product, just one row should be fetched or shown. I can do it through Laravel but I want to learn handling through database. If can, help.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire