From: Enver ALTIN (enver.altin@frontsite.com.tr)
Date: Tue 21 Oct 2003 - 09:50:26 EDT
Merhaba,
On Tue, 2003-10-21 at 16:43, Alper Oguz wrote:
> mysql> SELECT * FROM program
> -> WHERE program.progkod IN
> -> (SELECT kaset.progkod FROM kaset WHERE dolap=3D1);
> ERROR 1064: You have an error in your SQL syntax near 'SELECT kaset.progk=
od FROM kaset WHERE dolap=3D1)' at line 3
Bu i=FE zaten b=F6yle yap=FDlmaz :)
SELECT p.*,k.* FROM program p INNER JOIN kaset ON p.program=3Dk.pro=
gkod WHERE k.dolap=3D1;
do=F0rusu san=FDr=FDm.
--=20
__________
| |
| | Enver ALTIN (a.k.a. skyblue)
| | Software developer, IT consultant
| FRONT |
|=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D| FrontSITE Bilgi Teknolojisi A.=DE.
|_____SITE_| http://www.frontsite.com.tr/