List:General Discussion« Previous MessageNext Message »
From:Amit Lonkar Date:August 17 2002 5:08am
Subject:Query problem
View as plain text  
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
Thread
Query problemAmit Lonkar17 Aug
  • Re: *****SPAM***** Query problemDavid Lloyd17 Aug
  • Re: Query problemFrancisco19 Aug