Hello marc,

yes you are right,that there is no need to explicitly ask the user to "select relation arrows",
but  i want to provide users with an option to select the Join type(inner,outer,left,right).

i have not mentioned any details for writing Nested Sub queries.till now i don't have a good design to implement them......and am still working on it.

Thanks
Ankit

2010/4/1 Marc Delisle <marc@infomarc.info>
ANKIT GUPTA a écrit :
> Hi,
>
> because of the size limit , i am resending the my previous mail but this
> time in place of attaching the image i am providing a URL
>
> URL for image:
> http://dl.dropbox.com/u/1008346/mock_schema.jpg
>
> PFA with this mail
> as marc Suggested that we should discuss the design with the help of an
> example,
> so i have made a mock schema with three tables artist,song and sings.details
> u can see in the diagram with this mail.
>
> i know The Design which i have developed till now is just the beginning
> draft , lot of discussion and thought has to be put to finalize the design
> with functionality.

Hi Ankit,

I had a look at your image. I'm not sure what you mean by "select the
relations arrows which we need for the query". I think that in a query
builder, the user should be able to specify what he needs just in terms
of tables and columns, and the product should build the correct joins.

--
Marc Delisle
http://infomarc.info

------------------------------------------------------------------------------
Download Intel&#174; Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel