Advertisement
abdurahman_argoebie

query for change sn by request higienis

Oct 28th, 2024
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.53 KB | Source Code | 0 0
  1. select cpd.id as customer_product_detail_id,
  2. c.customer_name,
  3. c.customer_phone,
  4. c.id as customer_id,
  5. cd.address,
  6. cpd.model_id,
  7. ms.id as serial_number_id,
  8. cpd.purchase_date,
  9. ms.serial_number from customer_product_detail cpd
  10. join customer c on c.id = cpd.customer_id
  11. join customer_delivery cd on cd.id = cpd.customer_delivery_id
  12. join model_sn ms on ms.id = cpd.model_sn_id
  13. where ms.serial_number in ('KPROL21200085','KProL21200085');
  14.  
  15.  
  16. select * from model_sn ms where serial_number in ('KPROL21200085','KProL21200085');
  17.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement