]/td
tdfont size=\-1\$r[deptemail3]/td
tdfont size=\-1\$r[deptmobile3]/td;
-Original Message-
From: Ross Goonan [mailto:[EMAIL PROTECTED]]
Sent: Friday, 8 June 2001 11:47
To: [EMAIL PROTECTED]
Subject: JOIN to the same table multiple times
tdfont size=\-1\$r[deptphone3]/td
tdfont size=\-1\$r[deptfax3]/td
tdfont size=\-1\$r[deptemail3]/td
tdfont size=\-1\$r[deptmobile3]/td;
-Original Message-
From: Ross Goonan [mailto:[EMAIL PROTECTED]]
Sent: Friday, 8 June 2001 11:47
To: [EMAIL PROTECTED]
Subject: JOIN to the same table
You really shouldn't be using SELECT *. Try SELECT S1.sitename AS
FirstSiteName, S2.sitename AS SecondSiteName, etc etc etc.
Ok, I've answered my own question but now have another.
How do I reference the sitename for the 3 sites?
sitename returns the last sitename for all 3 I tried
###
Creating a Telephone / Information Directory with MySQL / PHP3
People belong to a department a site.
Need to be able to:
List all people
List all people within a Department
List all people within a