Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- clientes
- - id 3
- - nome_cliente - Marcos
- funcionarios
- - id 5
- - nome_funcionario - Anthonella
- servicos
- - id
- - idcliente - 3
- - idfuncionario - 5
- SELECT servicos.*, clientes.nome_cliente, funcionarios.nome_funcionario FROM servicos
- INNER JOIN clientes ON servicos.idcliente = clientes.id // todas as infos do cliente
- INNER JOIN funcionarios ON servicos.idfuncionario = funcionarios.id // todas as infos do funcionário
- WHERE servicos.idcliente = 3 AND servicos.idfuncionario = 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement