SQL Query Designer, Analyzer, Builder

[Stylus VB]

I need a component which can build sql queries and supports drag&drop while building them also highlights the syntax. I tried to google with these keywords "SQL Query Designer, Analyzer, Builder" but no luck.

[Mycroft Holmes]

We use these guys - the paid version has a MUCH better SQL parsers. ActvieQuery[^]

Never underestimate the power of human stupidity RAH

[Tiyani Miyambo]

You can try to use Ms Access, it allow you to do drag and drop for tables, while you can still view the SQL syntax,

[Ageesh]

hi.. if u r using sql server u have t facility to make query. t thing u hav to do is to select t tables link t tables and pick t fields. t query is ready Rgrds Ageesh