ahmedrahil786

Query for Mohana - Finding Country for accident members

Dec 5th, 2019
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.22 KB | None | 0 0
  1. select distinct ma.member_id as mid,
  2. ma.country as country,
  3. if(ma.country="","Not Found",if(ma.country = 'MYS',"Local","International"))
  4. from member_appendixes ma
  5. where ma.member_id in ('4865',
  6. '7345',
  7. '10035',
  8. '11516')
Advertisement
Add Comment
Please, Sign In to add comment