mysql join question

id, agent_name, ticket_id, category, date_logged

id, agent_name, department, admin_status

SELECT * FROM Table1
      INNER JOIN Table2
      ON Table1.agent_name = Table2.agent_name
      WHERE Table2.department = 'somespecific value';

SELECT * FROM Table1
      INNER JOIN Table2
      ON Table1.agent_id = Table2.id
      WHERE Table2.department = 'somespecific value';

select
    a.id, a.agent_name, a.ticket_id,
    a.category, a.date_logged, b.department
from
    table1 a inner join table2 b on b.agent_name=a.agent_name

Table1: id, agent_id,  ticket_id, category, date_logged
Table2: agent_id, agent_name, department, admin_status

SELECT t2.agent_name, t1.date_logged FROM table1 t1
INNER JOIN table2 t2 ON t2.agent_id = t1.agent_id