Allow to enter criteria at the join level
Left join categories c on c.id = p.catgoryId and p.price > 100
This can be done in most SQL DBs, including SQL Server, but is not allowed in Access
4
votes
Patrick Honorez
shared this idea
1 comment
-
Andy Rice commented
I would use this.