Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- c.complaint_id,
- GROUP_CONCAT (DISTINCT file_path SEPARATOR '+ ' )
- from svk_apt_complaints c
- LEFT join svk_apt_master_complaints mc on mc.complaint_type_id = c.complaint_type_id and mc.is_active = 1
- 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