Thanks guys, works a treat. Yip, it was the Alias thing... interesting.
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "asherh" <[EMAIL PROTECTED]>
Sent: Wednesday, February 27, 2002 2:39 PM
Subject: RE
joins you are talking
about. I think I must be missing something fundamental here.
Chrs,
Ash
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: "asherh" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 27, 2002 9:12 AM
Su
Hi,
I am using MySQL 3.22.32 and are trying to accomplish the following (without
going into too much detail, this is an example of the exact situation)...
1) I have two tables:
a) User table containing: UserID, FullName
b) Project table containing: ProjectID, ProjectManagerID and ProjectOwner