Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select cpd.id as customer_product_detail_id,
- c.customer_name,
- c.customer_phone,
- c.id as customer_id,
- cd.address,
- cpd.model_id,
- ms.id as serial_number_id,
- cpd.purchase_date,
- ms.serial_number from customer_product_detail cpd
- join customer c on c.id = cpd.customer_id
- join customer_delivery cd on cd.id = cpd.customer_delivery_id
- join model_sn ms on ms.id = cpd.model_sn_id
- where ms.serial_number in ('KPROL21200085','KProL21200085');
- select * from model_sn ms where serial_number in ('KPROL21200085','KProL21200085');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement