[PHP-DB] One to Many Select Statement

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 1group_1 2 1group_2 Would this be the proper way to construct a select statement for this - select u.username,

Re: [PHP-DB] 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 1group_1 2 1group_2 Would this be the proper way to construct a select statement for this - select

Re: [PHP-DB] One to Many Select Statement

John Holmes wrote: 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 1group_1 2 1group_2 Would this be the proper way to construct a select statement