I'm having difficulty properly joining tables in L9. This joins my products and additionalProducts tables. The mission is to get all the products that can be added with productId(x). I have the Product table with all the info and additonalProduct that look like this:
| id | product_id | additionalProductId |
|---|---|---|
| 1 | 1 | 2 |
| 2 | 1 | 4 |
| 3 | 2 | 3 |
| 4 | 2 | 5 |
My Answer:
To properly join the Product and additionalProducts tables in Laravel, you can use the following query:
php
$productId = x; // Replace x with the desired productId
$products = DB::table('products')
->join('additionalProducts', 'products.id', '=', 'additionalProducts.product_id')
->where('additionalProducts.additionalProductId', $productId)
->select('products.*')
->get();
This query will join the two tables on the `id` column of the `products` table and the `product_id` column of the `additionalProducts` table. It will then filter the results based on the `additionalProductId` column matching the desired productId.
Make sure to replace `x` with the actual productId you want to filter by.
Rate this post
4 of 5 based on 5998 votesComments