I have two tables, one called TICKETS, and one called MEMBERS
These are the fields in question for TICKETS:
These are the fields in question for MEMBERS:
I have this so far:
select t.*, m.lastname, m.firstname
from tickets t, members m
where t.assigned_to = m.member_id
Gives me 602 records which is correct...
Works great, but as soon as I add:
and t.assigned_by = m.member_id
I only get 11 records....not sure how to properly "lookup" two fields in TICKETS from the same table (MEMBERS)..