At 11:40 -0400 26/9/06, Zembower, Kevin wrote:
IF(ISNULL(SELECT lv.langversionid
FROM langversion AS lv
JOIN baseitem AS b3 ON lv.baseitemid =
b3.baseitemid
WHERE lv.langid = "1"
AND b.baseitemid = lv.baseitemid
)), 'Y', 'N') AS "Lang Avail"
Looks to me as if your parentheses don't balance
here - you have an extra ')' in that last line.
--
Cheers... Chris
Highway 57 Web Development -- http://highway57.co.uk/
I once preached peaceful coexistence with Windows.
You may laugh at my expense - I deserve it.
-- Jean-Louis Gassé, former Apple executive (& Be CEO)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]