I need to use a GUI SQL Query builder in a demo in the near future. Is there a decent, open-source one that generates plain ANSI SQL? Preferably through ODBC, but JDBC might work as well. The folks ...

Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...