The result set produced by Left or Right joins is influenced by which direction
one moves the mouse during the selection of columns to join on.
IMO this leads to confusion on the part of some users, particularly less
experienced users that are not confident in their knowledge of SQL.

Open the attached odb file - run the 4 queries and look at each in the query
designer. The queries have names that designated both the type of JOIN and which
direction the mouse was dragged when the join was created.
ie. qry_left_join_L2R = a left join created by dragging the linked column from
the table on the left to the table on the right with the mouse.

Open the attached odg file for the pretty pictures..

Honestly I think this is actually a usability defect, but RFE is good also.

Possible changes:

1) None - it works just fine the way it is.

2) The drag direction should make no difference - Which table is on which side
of the join should be based solely on the placement of the table objects in the
query designer.

3) Some change to the UI, when the "Join Properties" dialog is not displayed so
that the user both knows which table is on the which 'side' of the join and what
type of join is being represented. ( perhaps I am mixing something new in the
last section of this option? )

Others ??