Guest User

Untitled

a guest
Jan 21st, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. SELECT
  2. c.complaint_id,
  3. GROUP_CONCAT (DISTINCT file_path SEPARATOR '+ ' )
  4. from svk_apt_complaints c
  5. LEFT join svk_apt_master_complaints mc on mc.complaint_type_id = c.complaint_type_id and mc.is_active = 1
  6. LEFT join svk_apt_complaints_docs cd on cd.complaint_id = c.complaint_id order by c.complaint_id
Add Comment
Please, Sign In to add comment