I am try to query one field twice which relates differently to another table.
For example:
SELECT u.full_name as user1, u.full_name as user2
FROM users u, work_request w, est_time e Where u.uid = w.uid and u.uid = e.uid and w.wo_id = 152
When I do this query user1 and user2 are always the same.
any ideas or place that I can read up on MySQL queries?
Thanks
For example:
SELECT u.full_name as user1, u.full_name as user2
FROM users u, work_request w, est_time e Where u.uid = w.uid and u.uid = e.uid and w.wo_id = 152
When I do this query user1 and user2 are always the same.
any ideas or place that I can read up on MySQL queries?
Thanks