Re: Subselect functionality

2003-06-25 Thread Nils Valentin
Thanks Mike for the response, I didnt even think for a moment that CREATE... SELECT, INSERT ...SELECT etc. wouldnt be a subselect command (also it is a nested query). I dont know why I didnt think about that. Mike you mentioned a very good point. Maybe I was thinking to focused to see the whol

RE: Subselect functionality

2003-06-25 Thread Mike Hillyer
I am not sure that could be viewed as a subselect, as it in not a SELECT within an SELECT, but is instead a SELECT within a CREATE. I would imagine that the SELECT within the CREATE is easier to implement that the actual SELECT within a SELECT. Regards, Mike Hillyer www.vbmysql.com > -Origin

Re: Subselect functionality

2003-06-25 Thread Nils Valentin
Hi Egor, Thank you for the reply. Do you mind to go abit mor into details ? It seems that I got domething wrong here. If nested queries are not only subselects, which other nested queries exist there ? Do you mind just writing a few samples, please ? Sorry if this seems a simple question - fr

Re: Subselect functionality

2003-06-25 Thread Egor Egorov
"Nils Valentin" <[EMAIL PROTECTED]> wrote: > > I have a question regarding the MySQL feaures. > > From Version 4.1 Full subselect support was/is announced. > > However if I understood correctly then already from Version3.23-41 (or > earlier) there are some subselect functions already included.