supports group by, order by, subqueries, union.

supports all types of join: inner, rigth-left-full outer, natural.

create joins with drag and drop, foreign keys or with csv definition.Second, your inner joins look to me as if they should be outer (left) joins. or command line utilities like: SQLTools++, PKlite. Currently trying to create FDB on the iMac using FlameRobin and RazorSQL. I left the last left-join as it is, because here the left join colunm is a different one. The main added feature to SQLeonardo (after bug fixing) is the ability to store all the joins definition in a local csv file, to generate SQL even when the database has no FK implemented or for views.Ĭan be compared with : FreeQueryBuilder (SQLeonardo ancestor), SQuirreL SQL, Active Query Builder, Flyspeed, Oracle SQLdeveloper, Toad, DbVisualizer. This reduces the first three joins to ITEMPROPERTY to a single left join.

This GUI supports virtually all JDBC drivers, including ODBC bridge, has been mainly tested with Oracle, Mysql, Firebird, HSQLDB, CsvJdbc.

SQLeo is a free open source SQL Query builder based on SQLeonardo.2009.03.rc1 (used in Jasper Reports and Pentaho), that permits to create complex sql queries easily as Access (Microsoft query) do. SQLeoVQB for Windows 10 - Full description

Multi left outer join in razorsql