HomeFlySpeed SQL QueryInner Join as where

Inner Join as where


First of all - congratulations to a well thought out tool, which really surprises me with its wast capabilities!

One question:
SELECT * FROM A, B WHERE A.id=B.id;
is correctly displayed as an inner join with disabled controls in the property window. Is it somehow possible to create such a link also with drag-and-drop? I seem to only be able to get
SELECT * FROM A Inner Join B on A.id=B.id

No big deal - but I find the 'Where' version easier to read in SQL and acquired a habit of formulating that way ...; so I was looking for an option to convince FlySpeed of following my habits, eg. through an option setting.

Again - great stuff anyway! Stefan
Stefan_E | email
September 1 2010, 05:49 PM
This topic is closed