Re: One to Many Select Statement

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"; ?> -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com