/ Published in: MySQL
(Player - Player Agent) Images
- SELECT asub.*,pr.type,
- WHEN pr.type='player' THEN (SELECT image FROM football_player_list WHERE user_id = pr.id)
- WHEN pr.type='player_agent' THEN (SELECT image FROM player_agent_list WHERE user_id = pr.id)
- ELSE '-' END as user_images
- FROM `agent_subscribe` as asub INNER JOIN profile as pr ON asub.member_id = pr.id WHERE player_id = 1
You need to login to post a comment.