|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
October 2nd, 2003, 02:12 PM
|
|||
|
|||
|
inner select "help please"
I am running 4.0.15-standard
Error SQL-query : SELECT colA FROM tabA WHERE colB IN ( SELECT colB FROM tabB WHERE colB = 1 AND colC >= 4 ) AND colA > 0 LIMIT 1 MySQL said: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT colB FROM tabB WHERE colB = 1 AND
|
|
#2
October 2nd, 2003, 04:05 PM
|
|||
|
|||
|
RE: inner select
The version of MySQL you are running does not support subselects... see the section on subselects in the MySQL manual, they offer some workarounds...
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > inner select "help please" |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
