Im using PHPGenerator for mysql to generate some pages at work.
Is it possible for me to do a MySQL query like below?
Or am i trying something thats impossible??
SELECT
training.id,
training.Employee_Name,
training.Team_Name,
training.Date_Requested,
training.Course_Information,
training.Training_Provided,
training.Time_Taken,
training.Trainer,
training.Critique_Completed,
training.Certification,
training.Comments,
training.file_name,
training.file_type,
training.file_size,
training.Training_Information_Given_Was,
training.Training_Course_Structure_Was,
training.Training_Instructor_Was,
training.Training_Instruction_Aids_Was,
training.Training_Aids_Used,
training.Online_Material_Used
FROM
training
WHERE
training.Training_Provided = 'No' AND
%current_user_id% = Userlist.Staff_name WHERE userlist.Role NOT LIKE 'Employee'