> Access. However, when I run it against MySQL I get an error. > select l.ltsysid,l.lientraknum, c.name from lientrak as l, customer as c > where l.custsysid=c.custsysid > and l.ltsysid in (select l2.ltsysid from lientrak as l2 where > l2.lientraknum > like '2003-%')
Sub queries are not going to be available until version 4.1. You'll need to re-write the above query using an outer (?) join. I'm not sure what the exact syntax should be and I'm sure someone will pipe up with that info. Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
