Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT `ip_clients`.`client_name`
- FROM `ip_products`, `ip_invoice_items`, `ip_invoices`, `ip_clients`
- WHERE `ip_products`.`product_id` = `ip_invoice_items`.`item_product_id`
- AND `ip_invoice_items`.`invoice_id` = `ip_invoices`.`invoice_id`
- AND `ip_invoices`.`client_id` = `ip_clients`.`client_id`
- AND `ip_products`.`product_name` = "test"
- AND `ip_invoices`.`invoice_status_id` > 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement