Is this even possible? I always end up with INNER JOIN after viewing the SQL that the wizard provides. I know how to write the query myself. I'm just trying to figure out if I should be selecting different options in the Query Wizard to make it do it automatically. Below, you'll find a description of what I'm expecting and my table designs:
The query should return all rows from TABLE_USERS. If a row in TABLE_USERS has data in the GroupName field, the query should return the GroupDescription from TABLE_GROUPS.
TABLE_USERS
Username
GroupName
TABLE_GROUPS
GroupName
GroupDescription