[sql:1:ff16c9a585]SELECT * FROM part_pkg WHERE ( disabled IS NULL OR disabled = "" ) AND 0 < ( SELECT COUNT(*) FROM type_pkgs WHERE typenum = 1 AND type_pkgs.pkgpart = part_pkg.pkgpart )[/sql:1:ff16c9a585]
jednak MySQL zwraca błąd:
Kod
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 COUNT(*) FROM type_pkgs WHERE typenum = 1
Co jest nie tak? Czy to zapytanie powinno wyglądać tak?
[sql:1:ff16c9a585]SELECT * FROM part_pkg WHERE ( disabled IS NULL OR disabled = "" ) AND 0 < ( SELECT COUNT(*) FROM type_pkgs WHERE (typenum = 1 AND type_pkgs.pkgpart = part_pkg.pkgpart) )[/sql:1:ff16c9a585]
Baza MySQL to: 4.0.16-log.