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."
Thanks, I did look at JOINS
SELECT * from TABLE_A
join TABLE_B on TABLE_A.userId = TABLE_B.userId
join TABLE_C on TABLE_B.groupId = TABLE_C.groupId
WHERE
TABLE_A.username = 'x'
But I am not sure this is the most efficient way of doing it.
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).