I am getting this error:
Not unique table/alias: 'request'1066
I checked my SELECT statement, and I can't find where the error is coming from. I also checked my database to make sure all the tables and columns existed...and they do.
Here is my SELECT statement:
SELECT request.id, request.date, request.type, request.status,
faculty.f_name, faculty.l_name, action.id, faculty.id FROM request INNER
JOIN faculty ON request.requested_by=faculty.id LEFT JOIN request ON
action.request_id=request.id
Any ideas?
thanx
Not unique table/alias: 'request'1066
I checked my SELECT statement, and I can't find where the error is coming from. I also checked my database to make sure all the tables and columns existed...and they do.
Here is my SELECT statement:
SELECT request.id, request.date, request.type, request.status,
faculty.f_name, faculty.l_name, action.id, faculty.id FROM request INNER
JOIN faculty ON request.requested_by=faculty.id LEFT JOIN request ON
action.request_id=request.id
Any ideas?
thanx