> Select User_Account from Users as a, Devices as b > WHERE > a.User_Account = (Select DISTINCT(b.Device_Account) from b.Devices > WHERE b.Device_Name LIKE 'HP%' )
> I'm running 3.23.49 which I know is not the most current..it was installed
3.x does not support subselects ("select x from (select y from ...)").
You'll need to upgrade to 4.1.
--
thanks,
Will
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
