Hi Chris,
Chris W wrote:
I have 2 queries to give me a list of names.
Q1:
SELECT DISTINCT FName, LName
FROM user u
JOIN userprofile p
USING ( UserID )
JOIN trainingstatus t
USING ( UserID )
WHERE ProgramID =12
ORDER BY LName, FName
Q2
SELECT DISTINCT FName, LName
FROM namelist
WHERE `Date`
Wh
I have 2 queries to give me a list of names.
Q1:
SELECT DISTINCT FName, LName
FROM user u
JOIN userprofile p
USING ( UserID )
JOIN trainingstatus t
USING ( UserID )
WHERE ProgramID =12
ORDER BY LName, FName
Q2
SELECT DISTINCT FName, LName
FROM namelist
WHERE `Date`
What I need is query that wil
