gmkrjs
asked on
left outer join
file A = StudentID, Name,grade file B= StudentID,AtRiskIndicator
In SQL how do I join file A and B so that my result set includes every row in file a and the AtRiskIndicator from file B only when the AtRiskIndicator = "High'
In SQL how do I join file A and B so that my result set includes every row in file a and the AtRiskIndicator from file B only when the AtRiskIndicator = "High'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL deals with tables, not files ...
Something like
select a.*
from fileA a
inner join fileB b
on a.StudentID = b.StudentID
where b.AtRiskIndicator = 'High' -- presuming that indecator is a character type
HTH
David
PS What database (and version) are you using?