Is there a mySQL frontend that has an interface for joins?

Are there any mySQL frontends, like phpmyadmin, that has a graphical interface for joins?

I know you can run saved queries (which may include joins) in phpmyadmin, but I am looking for a user-friendly way of how other frontends are tackling the problem. I don't actually need a frontend, I just want to see how others are doing it.

If there are none are available, what would be a good way of approaching creating a join interface?

I am currently thinking, given a student and enrollment table (as a super simple example), such that

student table
+---------------------------+
| id   | name   | number    |
+------+--------+-----------+
| 2    | Joe    | 04567843  |
| 3    | Jim    | 43243254  |
| 4    | Jack   | 23145671  |
+------+--------+-----------+

and..

enrollment 
+---------------------+------------+-----------+
| id   | student_id   | course_id  | score     |
+------+--------------+------------+-----------+
| 1    | 2            | ma001      | 86%       |
| 2    | 2            | en001      | 46%       |
| 3    | 3            | ma001      | 78%       |
+------+--------------+------------+-----------+

The interface could allow you to select a primary table, and the fields you want, then a secondary table, and the fields you want. And finally, a JOIN fieldset, where you choose the join type and开发者_高级运维 the fields connecting it (see image).

The image is a mockup using firebug manipulating phpmyadmin to show what I mean (hopefully)

I realise this is kind of 2 questions, but highly linked to each other, but to summarise, does a front end like this exist? And if not, would the above approach work?

A lot of tools provide this feature nowadays

SQLYOG is what I use... though I rarely use their query builder...they have one which allows joins ...

DB Forge has the query builder with the join feature included too... http://www.devart.com/dbforge/mysql/studio/ I was about to post the link to the query builder but this sites policy prohibits me from posting more than 2 links :(

Check out this link as it also has a screenshot included... smaller URL so have replace .'s for dot and /'s for slash

www dot activequerybuilder dot com slash screenshots.html

BTW MySQLs own tool which I feel is excellent also has this feature listed... http://dev.mysql.com/doc/query-browser/en/mysql-query-browser-using-graphicalbuilding.html

If you want to look at how others do it, play around with Microsoft Access a bit. e.g.

Not sure how good it is, but this one claims to visually create joins: http://www.cgiscriptshop.com/products/mdm/index.html

Right on the page it says:

Visually compose SELECT query, joining several tables.

You could check out Navicat Premium. It has a 'Visual SQL Builder' which sounds like what you're looking for.