Norman,
The SQL statement is this:
select s.first_name AS s_name, t.first_name AS t_name, f.date from
members s, members t,
schedule f where s.first_name=f.member1 and t.first_name=f.member2
The AS is optional but it works the same as aliasing table names in the
FROM clause.
$s_name | $t_name | date
Dan
__________________________________
Subject:
Join statement and output
Date:
Sat, 03 Mar 2001 22:43:27 -0800
From:
Norman Tan <[EMAIL PROTECTED]>
To:
[EMAIL PROTECTED]
No actual code, but hopefully, someone can help me through the theory
here.
I have 2 tables:
members - first_name, last_name
schedule - member1, member2, date
The SQL statement is this:
select s.first_name, t.first_name, f.date from members s, members t,
schedule f where s.first_name=f.member1 and t.first_name=f.member2
Now the output would look something like this.
| first_name | first_name | date |
Question is, in PHP, how would I distinguish the two first_name
fields? Database is currenly MySQL, but I would like this to be
database independant.
Thanks for your help.
--
Norman Tan
North Shore Interactive
http://www.nsmb.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
