Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT VoGroup.NAME,
- VoGroup.VEHICLE_OWNER_ID,
- VoGroup.VO_GROUP_ID,
- VoGroup.Parent_Vo_Group_Id,
- VoGroup.COMPANY_NR,
- gu.gui_user_id
- FROM (SELECT VoGroup.vo_Group_id,
- VoGroup.name,
- VoGroup.Vehicle_Owner_Id,
- VoGroup.Parent_Vo_Group_Id,
- VoGroup.COMPANY_NR
- FROM VO_GROUP VoGroup
- START WITH VoGroup.Parent_Vo_Group_Id IS NULL
- CONNECT BY VoGroup.Parent_Vo_Group_Id = PRIOR VoGroup.Vo_Group_Id
- ORDER SIBLINGS BY VoGroup.name) VoGroup,
- (SELECT * FROM gu_vehicle_owner
- WHERE gui_user_id = ?
- AND vehicle_owner_id = ?) gu
- WHERE VoGroup.vo_group_id = gu.vo_group_id(+)
- AND VoGroup.vehicle_owner_id = ?
Add Comment
Please, Sign In to add comment