Advertisement
Guest User

SQL query IP

a guest
Jan 7th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.38 KB | None | 0 0
  1. SELECT `ip_clients`.`client_name`
  2. FROM `ip_products`, `ip_invoice_items`, `ip_invoices`, `ip_clients`
  3. WHERE `ip_products`.`product_id` = `ip_invoice_items`.`item_product_id`
  4. AND `ip_invoice_items`.`invoice_id` = `ip_invoices`.`invoice_id`
  5. AND `ip_invoices`.`client_id` = `ip_clients`.`client_id`
  6. AND `ip_products`.`product_name` = "test"
  7. AND `ip_invoices`.`invoice_status_id` > 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement