Skip to Content
Former Member
Jul 09, 2016 at 11:10 AM

Left outer join and records filtering


Hi All,

In the below example I'd like to join two tables on EmployeeId in a way that in the final result dataset I get EmployeeId where type equals A or is null. I'd be easy to do through command but I need to do it through table choice not command. When I left outer join the tables and filter records on condition type=A or IsNull(type) records with type value null are eliminated. Could you please advise how to do it?

Table 1

EmployeeId 1 2 3

Table 2

EmployeeId Type 1 A 2 B 3

Result dataset:

EmplyeeId Type 1 A 3