EMfinanga
2 weeks ago
183
9
Laravel

JOIN Multiple tables

Posted 2 weeks ago by EMfinanga

hello Team i have 4 tables, i design a sales system and inventory, i want to evaluate the items

            1.  Items
                -id
                -name
                - category_id

         2. Credit_sales
                 -item_id
                 -customer_credit_id
                 -rate
                 -vch_no
                 -quantity
                 -amount
              
          3. Cash_sales
                 -item_id
                 -store_id
                 -customer_cash_id
                 -rate
                 -vch_no
                 -quantity
                 -amount

         4. itemsstock
                  -item_id
                 -store_id
                   -rate
                  -quantity
                 -amount

i want to select the id=3 then to get this format output

                   item_id
                   vch_no
                 -rate
                 -quantity
                 -amount
                 

Anyone can help me

Please sign in or create an account to participate in this conversation.