Change your query for: select red,green,blue from colorchanger INNER JOIN jobattributekit ON colorcode = value where attributekit = "Color" and jobnumber = "28200124RB4-001" and scenario="JN75K";
Also remember that MySQL does not allow sub-queries. --- Amit Lonkar <[EMAIL PROTECTED]> wrote: > Hi all > Does mysql support simple joins? > > 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"; > > ColorChanger Table:- > ColorCode Color Red Green Blue > STB BLUE 58 110 165 > > JOBATTRIBUTEKIT Table:- > Jobnumber Attributekit Value Scenario > 28200124RB4-001 Color STB JN75K > > > The error that it gives is :- > ERROR 1064: You have an error in your SQL syntax > near > 'select value from jobattr > ibutekit where attributekit = "Color" and jobnumber > = > "' at line 1 > > Thanks > Amit > > > > > > > > > __________________________________________________ > Do You Yahoo!? > HotJobs - Search Thousands of New Jobs > http://www.hotjobs.com > > --------------------------------------------------------------------- > 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 > __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com --------------------------------------------------------------------- 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