> 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]