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® 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