|
RE: Another SQL Question
Whatever works is good (and I hate these query setup dialogs)!
What does the "Details..." button do? It could be many things, but I wouldn't be surprised if it let you edit SQL directly somewhere under there. May be worth finding out, in case you need to use more advanced queries in your project in the future.
Other than that, the "Join by" box might become enabled if you specify columns from more than one table, or select more than one table somewhere before this dialog. Which might make self-joins a challenge, depending on how aware the dialog is of table aliasing...
| 
