Won't this be flat out wrong when something you're joining to has a condition in the where clause? Something like this: select * from Car inner join Color

Won't this be flat out wrong when something you're joining to has a condition in the where clause? Something like this: select * from Car inner join Color on Car.ColorId = Color.Id where Color.Name = 'Red' You can't get the correct paginated list of car id's without doing the join in the first query. Even more wrong if you're ordering off the joined table.