Untitled

	
select tom.app_seq_no as orderId, tom.product_type_fk, tom.status, tom.business_id_fk, tom.total_paid_amount, tom.total_discount_amount, tcd.app_seq_no as cartId
from `te_order_master` as tom inner join `te_cart_details` as tcd on tom.id = tcd.master_order_id_fk where tom.app_seq_no = "nxOrder_0BA0VUYGBc1111"