Amit,
> I am trying to run the following query:- > > select red,green,blue from colorchanger where > colorcode = select value from jobattributekit where > attributekit = "Color" and jobnumber = > "28200124RB4-001" and scenario="JN75K"; It doesn't support subselects. It's having a problem with the second select... I believe that "subselects" are on the wish list and will (eventually) appear but not at the moment in a stable release. DSL mysql, query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php