Re: Help on cross table Query

2001-07-10 Thread Timothy Smith
On 2001 Jul 10, Yan Zhang <[EMAIL PROTECTED]> wrote: > Please help me here, and let me know if MySQL can do it or not. All people > around me told it should work in SyBASE. Please don't spam! Use *one* e-mail address that is appropriate. This is on our list of things to do, probably in version

Re: Help on cross table Query

2001-07-10 Thread Dibo Chen
No, MySQL does not support subquery so you need work around (not use) it, by creating temp tbl and/or join etc. Think it a diff. SQL style. Yan Zhang wrote: > > Please help me here, and let me know if MySQL can do it or not. All people > around me told it should work in SyBASE. > > Yan Zhang >

Help on cross table Query

2001-07-10 Thread Yan Zhang
Please help me here, and let me know if MySQL can do it or not. All people around me told it should work in SyBASE. Yan Zhang [EMAIL PROTECTED] >> I have two tables: mysql> show tables; +--+ | Tables_in_vendor