Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2005
    Posts
    116

    Unanswered: Tool to generate query based on schema

    Hi Guys,

    If anyone has used any good tools that can help me in generating query/query builder, hope you dont mind sharing it with me,

    Because currently i have a complicated schema, and im kind of using combination of 3 or 4 separate queries to get the results, it would be good
    to combine it in a single query and get same results

    So if you have a tool which can assist me in generating complex quieries based
    "with a graphical user interface": such just dragging&dropping from the database schema,
    hope you can recommend me, through this tool, i would be able to learn how to write complicated query at the same time

    thank you very much
    Last edited by a1jit; 03-12-06 at 06:32.

  2. #2
    Join Date
    May 2005
    Location
    Hull
    Posts
    22
    Sorry, but I am a little confussed.

    Are you basically wanting a GUI Query Builder.
    "I hate quotes, tell me what you know"

  3. #3
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Query Reporter from Allround Automations comes to mind, though I must admit I've never tried the GUI SQL builder part, as I always just write the SQL myself. This type of tool always seems to me to be a complicated way to build simple joins and filters that you could more easily write yourself, and no help in writing anything complex. You could give it a shot though, as it's free.

  4. #4
    Join Date
    Feb 2005
    Posts
    116
    Quote Originally Posted by DA Master
    Sorry, but I am a little confussed.

    Are you basically wanting a GUI Query Builder.
    hi,
    thanks william, yup im looking for a GUI Query Builder..
    Or any good books where it can get me started wit building beginners level query up to advanced..

    I dont know why im finding difficulties building up good queries..
    Any good books on building queries would be appreciated..
    thanks..

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >yup im looking for a GUI Query Builder
    It is only as good as the person using it.
    If you can't create "correct" SQL in the editor of choice,
    a GUI Query Builder will NOT produce "correct" results either.
    GIGO.

    Keep in mind that SQL will ALWAY produce a results set.
    Whether or not the results set is 'correct' is programmer dependent.

    SQL for Dummies (Paperback)
    by Allen G. Taylor "SQL (short for structured query language) is an industry-standard language specifically designed to enable people to create databases, add new data to databases, ...
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Feb 2005
    Posts
    116
    [QUOTE=anacedent]>yup im looking for a GUI Query Builder
    It is only as good as the person using it.
    If you can't create "correct" SQL in the editor of choice,
    a GUI Query Builder will NOT produce "correct" results either.
    GIGO.
    QUOTE]

    i agree with you anacendent..thanks..i think i rather learn up than finding an easy way out...thanks for the book recommendation as well..appreciate it

  7. #7
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    Quote Originally Posted by a1jit
    ... currently i have a complicated schema, and im kind of using combination of 3 or 4 separate queries to get the results,
    You are on the right track, a complex query begins by building the simple pasts first and then combining into the one complexity.

    Good Luck!

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •