I only know the tools for mysql that creates sql query very very easy...
sqlyog which made sql query for me to join 10 tables in only 5 seconds...
and navicat can do the same work ..
the work for database I use the sqlyog ,
and the work for designing the website , I use the webassist extensions.. (even though I am just a newbie ^^" )