Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- output_id, output
- Central: central_id, output_id, central_data
- Central_2_A: central_id, property_A_id
- Property_A: property_A_id, property_A
- Central_2_B: central_id, property_B_id
- Property_B: property_B_id, property_B
- Central_2_C: central_id, property_C_id
- Property_C: property_C_id, property_C
- knex('Central').select(
- Central.central_id
- Central.output_id
- Central.central_data
- Property_A.property_A_id
- Property_A.property_A
- Property_B.property_B_id
- Property_B.property_B
- Property_C.property_C_id
- Property_C.property_C
- )
- .leftJoin('Central_2_A','Central_2_A.central_id','Central.central_id')
- .leftJoin('Property_A','Property_A.property_A_id','Central_2_A.property_A_id')
- .leftJoin('Central_2_B','Central_2_B.central_id','Central.central_id')
- .leftJoin('Property_B','Property_B.property_B_id','Central_2_B.property_B_id')
- .leftJoin('Central_2_C','Central_2_C.central_id','Central.central_id')
- .leftJoin('Property_C','Property_C.property_C_id','Central_2_A.property_C_id')
Add Comment
Please, Sign In to add comment