https://www.youtube.com/watch?v=PF6zdhTdyOs


SELECT
    c.`id`,
    `customer_name`,
    `customer_phone`,
    c.`created_at`,
    c.`is_deleted`,
   
    #customers
    `sub_category_name`,`price`,
    #subcategory
    `category_name`,
    #category
    
    `invoice_no`,`auto_gen_id`,
    `sub_total`,`discount`,`total`,`paid`,`balance`,di.`created_at`,
    #dressinvoice
    `amount`,
    #dressorder
    `username`
    
FROM
    `customers` c,
    `sub_category` sc,
    `category` cat,
    `dress_invoices` di,
    `dress_orders` dos,
    `app_users` au
WHERE
    c.id = di.customer_id AND cat.id = sc.category_id AND sc.id = dos.sub_cat_id AND di.id = dos.invoice_id
    AND au.id = di.user_id
    




SELECT
    c.`id`,
    `customer_name`,
    `customer_phone`,
    c.`created_at`,
    c.`is_deleted`,
    
    #customers
    
    `invoice_no`,
    `auto_gen_id`,
    `sub_total`,
    `discount`,
    `total`,
    `paid`,
    `balance`,
    #dressinvoice
    `username`
    #users
FROM
    `customers` c,
    `sub_category` sc,
    `category` cat,
    `dress_invoices` di,
    `dress_orders` dos,
    `app_users` au
WHERE
    c.id = di.customer_id AND cat.id = sc.category_id AND sc.id = dos.sub_cat_id AND di.id = dos.invoice_id AND au.id = di.user_id
GROUP BY
    invoice_no