Guest User

Untitled

a guest
Jan 4th, 2018
713
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. Ap_id Username Email password
  2. 1 Elen_zey Alan@gmail.com 123456
  3. 2 Morgan_jam Morgan@gmail.com 443556
  4. 3 Alex_Hales Alex@gmail.com 534545
  5.  
  6. Ap_id FirstName LastName Contact CNIC
  7. 1 Alan Zey 214343555 4663-14334-1
  8. 2 Morgan Jam 984209482 2663-14334-4
  9. 3 Alex Hales 343453453 7663-14334-2
  10.  
  11. Ap_id organization Designation Total Experience
  12. 1 10 Pearls Intern 20 Months
  13. 2 Radium Inc SQA 36 Months
  14. 3 Sper Inc Intern 46 Months
  15.  
  16. SELECT GROUP_CONCAT(DISTINCT CONCAT(aper.FirstName," ",aper.LastName)) AS
  17. Name, GROUP_CONCAT(DISTINCT ap.Email), GROUP_CONCAT(DISTINCT aper.Contact),
  18. GROUP_CONCAT(DISTINCT apro.totalExperience) AS Experience FROM
  19. applicant_personal_info aper INNER JOIN applicant ap ON aper.ApplicantID =
  20. ap.ApplicantID INNER JOIN applicant_professional_info apro ON
  21. aper.ApplicantID = apro.ApplicantID WHERE apro.totalExperience >=10
  22.  
  23. Name : 'Alan Zey, Morgan Jam, Alex Hales',
  24. Email : 'Alan@gmail.com, Morgan@gmail.com,Alex@gmail.com',
  25. Contact : '214343555,984209482,343453453',
  26. Experience : '20,36,46'
  27.  
  28. Name : Alan Zey,
  29. Email : Alan@gmail.com,
  30. Contact : 214343555,
  31. Experience : 20
  32.  
  33. Name : Morgan Jam,
  34. Email : Mirgan@gmail.com,
  35. Contact : 984209482 ,
  36. Experience : 36
  37.  
  38. Name : Alex Hales,
  39. Email : Alex@gmail.com,
  40. Contact : 343453453,
  41. Experience : 46
Add Comment
Please, Sign In to add comment