Re: SubQueries and Temp Tables

2002-06-27 Thread Gerald Clark
RDBMSs. Give us a >break. > >>-Original Message- >>From: Andrew Houghton [mailto:[EMAIL PROTECTED]] >>Sent: Thursday, June 27, 2002 9:10 AM >>To: Dave Morse >>Cc: 'Paul DuBois'; 'Arul'; [EMAIL PROTECTED]; 'MySQL' >>Subjec

RE: SubQueries and Temp Tables

2002-06-27 Thread Dave Morse
[EMAIL PROTECTED]] > Sent: Thursday, June 27, 2002 9:10 AM > To: Dave Morse > Cc: 'Paul DuBois'; 'Arul'; [EMAIL PROTECTED]; 'MySQL' > Subject: Re: SubQueries and Temp Tables > > > It makes sense to many, or most, I'd say. Oracle produce

Re: SubQueries and Temp Tables

2002-06-27 Thread Frank Gates
ource" server in C and a > client in Java makes sense, I guess to some. > > > -Original Message- > > From: Paul DuBois [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, June 26, 2002 5:37 PM > > To: Dave Morse; 'Arul'; [EMAIL PROTECTED] > > Cc:

Re: SubQueries and Temp Tables

2002-06-27 Thread Andrew Houghton
ednesday, June 26, 2002 5:37 PM >>To: Dave Morse; 'Arul'; [EMAIL PROTECTED] >>Cc: 'MySQL' >>Subject: RE: SubQueries and Temp Tables >> >> >>At 7:16 -0700 6/26/02, Dave Morse wrote: >> >>>MySQL is barely an SQL database - it doesn'

RE: SubQueries and Temp Tables

2002-06-27 Thread Paul DuBois
a, do you require a Web server to be written in Java before you'll connect to it? > >> -Original Message- >> From: Paul DuBois [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, June 26, 2002 5:37 PM >> To: Dave Morse; 'Arul'; [EMAIL PROTECTED]

RE: SubQueries and Temp Tables

2002-06-27 Thread Dave Morse
; [EMAIL PROTECTED] > Cc: 'MySQL' > Subject: RE: SubQueries and Temp Tables > > > At 7:16 -0700 6/26/02, Dave Morse wrote: > >MySQL is barely an SQL database - it doesn't support much > basic SQL 89 > >functionality. Can any one throw some light on why profes

RE: SubQueries and Temp Tables

2002-06-26 Thread Paul DuBois
At 7:16 -0700 6/26/02, Dave Morse wrote: >MySQL is barely an SQL database - it doesn't support much basic SQL 89 >functionality. Can any one throw some light on why professional SQL >database developers want to use it for anything but simple file >management? AND It is written in C as well so why

Re: SubQueries and Temp Tables

2002-06-26 Thread Alexander Barkov
gt; - Original Message - > From: "Ralf Narozny" <[EMAIL PROTECTED]> > To: "Arul" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]> > Sent: Wednesday, June 26, 2002 3:00 PM > Subject: Re: SubQuerie

RE: SubQueries and Temp Tables

2002-06-26 Thread Dave Morse
MySQL is barely an SQL database - it doesn't support much basic SQL 89 functionality. Can any one throw some light on why professional SQL database developers want to use it for anything but simple file management? AND It is written in C as well so why do Java developers use it? Regards, Dave

Re: SubQueries and Temp Tables

2002-06-26 Thread Arul
;MySQL" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 3:00 PM Subject: Re: SubQueries and Temp Tables > Hiho hiho! > > Which joins could that be? I think most if not all subqueries should be > replacable with joins. > > Greetings > Ralf > > Arul wrote

Re: SubQueries and Temp Tables

2002-06-26 Thread Ralf Narozny
Hiho hiho! Which joins could that be? I think most if not all subqueries should be replacable with joins. Greetings Ralf Arul wrote: >Hi All > > I am currently porting our application from Oracle to MySQL. >We have some subqueries in oracle which cannot be ported into MySQL.We even >tried so