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
