﻿SELECT * 
FROM moritz.agents;

SELECT * 
FROM moritz.services;

SELECT * 
FROM moritz.agents, moritz.services;

SELECT agents.id as agent, agents.id_service as id_service, services.id service 
FROM moritz.agents, moritz.services;

SELECT agents.id as agent, agents.id_service as id_service, services.id service 
FROM moritz.agents, moritz.services 
WHERE agents.id_service=services.id;

SELECT agents.id as agent, agents.id_service as id_service, services.id service 
FROM moritz.agents, moritz.services 
WHERE agents.id_service=services.id AND services.id=2;

SELECT agents.id as agent, agents.id_service as id_service, services.id service 
FROM moritz.agents JOIN moritz.services ON (agents.id_service=services.id)
WHERE services.id=2;