I have column called Response in EmpQueries table which holds multile fields values based on QueryID
For Ex: If QueryID = 'EICONS' -- Response column will give "Employer to be assigned"
If QueryID = 'EIRCONS' - Response Column will give "Reason for Assigned" Value..
So i need to show both these columns ("Employer to be assigned" and "Reason for Assigned" ) in my results in below query.. but as of now i am able to show only "Employer to be assigned" value by giving QueryID = 'EICONS' ...
I am not sure how i can show both the columns .. I new to SQL programming..Below is the query which i have return.
How can i get "Reason for Assigned" column ?
select SD.RollNumber ,SD.Name As 'Student Name',EmpID As 'Requesting Employer',Eq.Response as 'Employer to be assigned',
** from EmpInfo Ei**
** INNER JOIN EmpQueries Eq**
** on Ei.OrderID = eq.OrderID**
** inner JOIN StudentsData SD**
** ON Ei.VisitID = SD.VisitID **
** where Category = 'CONS' and Ei.Status not in ('CANC') **
** and DateTime between '2017-03-23 00:00:00' and '2017-03-23 23:59:59'**
** and Eq.QueryID = 'EICONS'**
Order by EmpID
Thank you ...