Gerard Samuel wrote:
Looking for clarification... Say that I have a user table and group table ->
-- user table -- id username 1 foo
-- group table -- id user_id group_name 1 1 group_1 2 1 group_2
Would this be the proper way to construct a select statement for this -> select u.username, g.group_name from user u, group g where u.user.id = g.user_id and user.id = 1;
The results should look like this -> username group_name foo group 1 foo group 2
What I would like to clarify, is if this is the proper (only) way to construct a one to many select statement?
I've always thought I was doing something illegal, since username is displayed more than once, and I would like to shake that thought
off my back.
Other than using "u.user.id" and "user.id" instead of "u.id" (just typos, I'm sure), there's nothing really wrong with that query. You can do that join this way, though, which may be more "proper":
SELECT u.username, g.group_name FROM user u JOIN group g ON u.id = g.id WHERE u.id = 1
oh, and <?php echo "PHP stuff"; ?>
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php