Click here to Skip to main content
15,920,217 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi, I would like to join 2 tables, bom and material_master

quantity from bom * price from material_master

the common field is mm_id
Mohibur Rashid 26-Jan-16 4:55am    
along with OriginalGriff's answer, you can also try this:
SELECT b.`quantity` * m.`price` FROM `material_master` m, `bom` b WHERE b.`mm_id` = m.`ID`

1 solution

SELECT b.quantity * m.price FROM material_master m
JOIN bom b ON b.mm_id = m.ID
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900