Use column-aliasing. To rename a column use the SQL "AS" syntax. Ie.
SELECT first_name AS fname ..
now "fname" is column name in the result set...Do this for each of your
first_name's, obviously using different names and you are set.
/cody caughlan
Norman Tan wrote:
> No actual code, but
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