|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
can someone help me to convert the following
subquery to common inner join statement: SELECT table1.id, table1.desc FROM table1 WHERE table1.id IN ( SELECT table2.id, table2.desc FROM table2 WHERE table2.id = table1.id AND table2.desc LIKE "%keyword%" ) the second SQL statement may result multiple rows but i don't want the side effeect which cartesian multiplication generated by inner join, i only want one! thank you. |
|
#2
|
|||
|
|||
|
select table1.id,table1.desc as desc1,table2.desc as desc2 from table1,table2 where table1.id=table2.id and desc2 like "%keyword%";
Just a quick note, desc is not allowed as a column name in mysql. |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > how to convert subquery to inner join? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|