Datanory Production » Datanory - SNEKKU

SELECT * FROM txn_sales_order_header WHERE order_no LIKE '%SOMS6000173%'
-- b9dae08e-9058-484c-bb51-2cb0793c2edd (Order Header id)

-- to get the specific product to check its quantity..
select * from txn_sales_order_details where ord_hdr_id = 'b9dae08e-9058-484c-bb51-2cb0793c2edd' and product_id= 'ec1859a1-dad1-4710-abf2-447c0b638e11';
-- To get invoice number
select * from txn_invoice_history_header where member_id='d185b37a8e764c4c869165a95ed693d0' and customer_id='60781D020FE64098820DFF6C1B982BD6';

select * from txn_mobile_header where customer_id='60781D020FE64098820DFF6C1B982BD6';

--inner join function perform to get the product details 
  SELECT *
FROM product_item
INNER JOIN txn_sales_order_details ON product_item.item_id = txn_sales_order_details.product_id
WHERE txn_sales_order_details.ord_hdr_id = 'b9dae08e-9058-484c-bb51-2cb0793c2edd' and item_code='BM131DF01003';