I read on the forum that FMP 10 did not (yet, at least) support left outer joins (right outer joins, full outer joins). Not sure about 11.
These types of joins seem like an important (as I understand it, missing) feature that would be easy to use if there were some type of "Save SQL as Find". I'd even settle for a SQL "command window" where I could do interactive queries.
Without right/left outer joins, I'm guessing there may be a cludge work-around.
Hopefully, FMP will eventually have some type of SQL interface for the product itself.
It's so nice to use FMP, I'm sad when things like this seem to be missing.
Any hope (guess if it will be supported) for any type of SQL support in 12?