Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Ap_id Username Email password
- 1 Elen_zey Alan@gmail.com 123456
- 2 Morgan_jam Morgan@gmail.com 443556
- 3 Alex_Hales Alex@gmail.com 534545
- Ap_id FirstName LastName Contact CNIC
- 1 Alan Zey 214343555 4663-14334-1
- 2 Morgan Jam 984209482 2663-14334-4
- 3 Alex Hales 343453453 7663-14334-2
- Ap_id organization Designation Total Experience
- 1 10 Pearls Intern 20 Months
- 2 Radium Inc SQA 36 Months
- 3 Sper Inc Intern 46 Months
- SELECT GROUP_CONCAT(DISTINCT CONCAT(aper.FirstName," ",aper.LastName)) AS
- Name, GROUP_CONCAT(DISTINCT ap.Email), GROUP_CONCAT(DISTINCT aper.Contact),
- GROUP_CONCAT(DISTINCT apro.totalExperience) AS Experience FROM
- applicant_personal_info aper INNER JOIN applicant ap ON aper.ApplicantID =
- ap.ApplicantID INNER JOIN applicant_professional_info apro ON
- aper.ApplicantID = apro.ApplicantID WHERE apro.totalExperience >=10
- Name : 'Alan Zey, Morgan Jam, Alex Hales',
- Email : 'Alan@gmail.com, Morgan@gmail.com,Alex@gmail.com',
- Contact : '214343555,984209482,343453453',
- Experience : '20,36,46'
- Name : Alan Zey,
- Email : Alan@gmail.com,
- Contact : 214343555,
- Experience : 20
- Name : Morgan Jam,
- Email : Mirgan@gmail.com,
- Contact : 984209482 ,
- Experience : 36
- Name : Alex Hales,
- Email : Alex@gmail.com,
- Contact : 343453453,
- Experience : 46
Add Comment
Please, Sign In to add comment