Pavel Lepin;101603 Wrote:
>
>
> ....you should use JOINs. Read about JOIN syntax in MySQL
> Reference Manual.
>
> --
> "I can't help but wonder if you... don't know a hell of a
> lot more about practically every subject than Solomon ever
> did."
Sorry for the double reply.
But why would a JOIN be better than a multiple select?
I could so
SELECT TABLE_C.* FROM TABLE_A, TABLE_B, TABLE_B
WHERE
TABLE_C.permission = TABLE_B.permission
AND
TABLE_B.userID = TABLE_A.userID
AND
TABLE_A.username = 'x'
And in my case get the same result, what would be the 'better' way of
selecting the permissions?
FFMG
--
'webmaster forum' (
http://www.httppoint.com) | 'Free Blogs'
(
http://www.journalhome.com/) | 'webmaster Directory'
(
http://www.webhostshunter.com/)
'Recreation Vehicle insurance'
(
http://www.insurance-owl.com/other/car_rec.php) | 'Free URL
redirection service' (
http://urlkick.com/)
------------------------------------------------------------------------
FFMG's Profile:
http://www.httppoint.com/member.php?userid=580
View this thread:
http://www.httppoint.com/showthread.php?t=21905
Message Posted via the webmaster forum
http://www.httppoint.com, (Ad revenue sharing).