Feedback by UserVoice

I suggest you ...

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
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Patrick Honorez shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Dick Watson commented  ·   ·  Flag as inappropriate

        You can do this by editing the SQL by hand in the pathetic Assess SQL editor. Once you do this, the QBE grid becomes useless and/or destructive to your query.

        As a more generalized solution, this should be added to the QBE grid as, say, a click box on the relation line that allows a non equi-join to be defined/indicated for that relationship. QBE should also get the ability to define/edit a subquery.

      Feedback and Knowledge Base