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
Posted
Comments
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

Try:
SQL
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