----- Original Message ----- From: "Chris Boget" <[EMAIL PROTECTED]> To: "Greg Jones" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, December 02, 2003 8:32 AM Subject: Re: Query Help
> > 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. First impression: it looks like it might be messy if ltsysid isn't unique (i.e., isn't a key). > Chris > > > -- > 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]
