Re: visualize SQL join statement

[Dennis Becker]

I only know the implementation of "MS Access" - I usually use a small self-written script where I can write SQL-Statements in an textarea seperated with semicolons (this script ist faster than phpMyAdmin and is like a reimplementation of a tool of oracle in the past).

The "Visual Query Builder" would also help for creating views - the user should be able to choose if he wants to write the SQL by himself or let it create such a builder - but you should always be able to change the statement before you export it!


I would like to see also a connection to live database server or to an internal debug database where you can add testing data (or using your live data) so that you can directly see how the resultset looks like. This would also could speed up developing if application-developers have access to this .mwb file and get a better overview.