Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT VGuiUserOcPoi.poi_id, vpc.vo_person_category_id, VGuiUserOcPoi.name, VGuiUserOcPoi.short_name
- FROM V_GUI_USER_OC_POI VGuiUserOcPoi, vo_person_category vpc
- WHERE
- VGuiUserOcPoi.oc_poi_category_id = vpc.hiring_p_oc_poi_category_id
- AND VGuiUserOcPoi.OC_POI_STATUS_ID IN (0,3)
- AND (VGuiUserOcPoi.gui_user_id = ?)
- ORDER BY name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement