Guest User

Untitled

a guest
Jan 16th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. output_id, output
  2. Central: central_id, output_id, central_data
  3. Central_2_A: central_id, property_A_id
  4. Property_A: property_A_id, property_A
  5. Central_2_B: central_id, property_B_id
  6. Property_B: property_B_id, property_B
  7. Central_2_C: central_id, property_C_id
  8. Property_C: property_C_id, property_C
  9.  
  10. knex('Central').select(
  11. Central.central_id
  12. Central.output_id
  13. Central.central_data
  14. Property_A.property_A_id
  15. Property_A.property_A
  16. Property_B.property_B_id
  17. Property_B.property_B
  18. Property_C.property_C_id
  19. Property_C.property_C
  20. )
  21. .leftJoin('Central_2_A','Central_2_A.central_id','Central.central_id')
  22. .leftJoin('Property_A','Property_A.property_A_id','Central_2_A.property_A_id')
  23. .leftJoin('Central_2_B','Central_2_B.central_id','Central.central_id')
  24. .leftJoin('Property_B','Property_B.property_B_id','Central_2_B.property_B_id')
  25. .leftJoin('Central_2_C','Central_2_C.central_id','Central.central_id')
  26. .leftJoin('Property_C','Property_C.property_C_id','Central_2_A.property_C_id')
Add Comment
Please, Sign In to add comment