Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. SELECT
  2. `core_customer`.`id`, `core_customer`.`name`,
  3. `core_customer`.`organization_number`,
  4. `core_customer`.`disable_auto_creation_of_invoices`
  5. FROM `core_customer` WHERE `core_customer`.`id` IN (SELECT
  6. DISTINCT U0.`customer_id`
  7. FROM `time_report_timereportentry` U0)
  8.  
  9. SELECT
  10. `core_customer`.`id`, `core_customer`.`name`,
  11. `core_customer`.`organization_number`,
  12. `core_customer`.`disable_auto_creation_of_invoices`
  13. FROM `core_customer` WHERE `core_customer`.`id` IN (SELECT
  14. DISTINCT U0.`customer_id` AS Col1
  15. FROM `time_report_timereportentry` U0) ORDER BY `core_customer`.`name` ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement