question

It looks like you need to filter out the rows not columns and your criteria is that you only want to include those rows in the outcome which have some information. For example, suppose for ServiceRequestID = 1 there is data in ServiceD. This is good enough to include the row even though other tables don't have any info. However, if ServiceRequestID = 1 has no values in any of the tables on the right hand side (all except ServiceRequest table itself) then this row should not be included. In this case, one way to go is to add (admittedly nasty looking) predicate which will check all included in the select list columns from ServiceA, ServiceB, ServiceC, ServiceD, and ServiceE and include the row only if at least one column has a useful value. For example, suppose you statement includes all columns from ServiceRequest and 2 columns from each of the tables on the right hand side (I will call then ColA and ColB for the sake of this sample). In this case, you statement will (sadly) look like this: select r.*, a.ColA, a.ColB, b.ColA, b.ColB, c.ColA, c.ColB, d.ColA, d.ColB, e.ColA, e.ColB from ServiceRequest r left join ServiceA a on r.ServiceRequestID = a.ServiceRequestID left join ServiceB b on r.ServiceRequestID = b.ServiceRequestID left join ServiceC c on r.ServiceRequestID = c.ServiceRequestID left join ServiceD d on r.ServiceRequestID = d.ServiceRequestID left join ServiceE e on r.ServiceRequestID = e.ServiceRequestID where -- this is that nasty part :( (a.ColA is not null) or (a.ColB is not null) or (b.ColA is not null) or (b.ColB is not null) or (c.ColA is not null) or (c.ColB is not null) or (d.ColA is not null) or (d.ColB is not null) or (e.ColA is not null) or (e.ColB is not null); go In case if all columns from tables on the right hand side do have values if you have a match (or you simply want to include them anyway) then you can reduce the ugliness of the predicate a bit by only checking the ServiceRequestID for null. In other words, include the row in the results is there is an actual match in any of the 5 tables on the right hand side: select [YOUR_COLUMNS_LIST] from ServiceRequest r left join ServiceA a on r.ServiceRequestID = a.ServiceRequestID left join ServiceB b on r.ServiceRequestID = b.ServiceRequestID left join ServiceC c on r.ServiceRequestID = c.ServiceRequestID left join ServiceD d on r.ServiceRequestID = d.ServiceRequestID left join ServiceE e on r.ServiceRequestID = e.ServiceRequestID where (a.ServiceRequestID is not null) or (b.ServiceRequestID is not null) or (c.ServiceRequestID is not null) or (d.ServiceRequestID is not null) or (e.ServiceRequestID is not null); go Oleg