Hi boka Nope sub-selects to my understanding ar only supported from version 4.1 onwards (still in beta I think)
Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] "There are 10 kinds of people in this world, those who understand binary and those who don't" (Unknown) ----- Original Message ----- From: "boka" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 11:54 AM Subject: MySQL 3.23.58 and sub-seletcs > Hi ! > > Are sub-selects supported by MySQL 3.23.58, because below query does not > work (syntax error in console): > > select iphdr.ip_src, timestamp \ > from iphdr , acid_event \ > where iphdr.sid = acid_event.sid \ > and iphdr.cid = acid_event.cid \ > and acid_event.sig_name = "STATEMENT" \ > and acid_event.timestamp > select max(another_database.dataz.timestamp) > \ from another_database.dataz; > > greetz > boka > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]