Advertisement
chrissharp123

Untitled

Nov 28th, 2017
220
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT  "ausp".id,
  2.         "ausp".set_date,
  3.         "ausp".usr,
  4.         "ausp".staff,
  5.         "ausp".standing_penalty,
  6.         "ausp".org_unit,
  7.         "ausp".stop_date,
  8.         "ausp".note
  9. FROM actor.usr_standing_penalty AS "ausp"  
  10.         LEFT JOIN config.standing_penalty AS "__standing_penalty.block_list_csp" ON ( "__standing_penalty.block_list_csp".id = "ausp".standing_penalty )  
  11.         LEFT JOIN actor.org_unit AS "__org_unit.shortname_aou" ON ( "__org_unit.shortname_aou".id = "ausp".org_unit )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement