Query question

Last Post 13 Aug 2014 08:38 AM by dstoltz. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Resolved
dstoltz
New Member
New Member

--
07 Aug 2014 07:27 AM
I have two tables, one called TICKETS, and one called MEMBERS

These are the fields in question for TICKETS:
ticket_id
assigned_to
assigned_by

These are the fields in question for MEMBERS:
firstname
lastname

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)..

Any help?
dstoltz
New Member
New Member

--
13 Aug 2014 08:38 AM
Never mind...
You are not authorized to post a reply.

Acceptable Use Policy