Re: Agrupar duas linhas de consulta em uma
Sim, Marcelo, desculpe.
Aqui está a tabela servicosalao:
CREATE TABLE `salao`.`servicosalao` (
`codigo_servicosalao` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email_salao` varchar(60) CHARACTER SET latin1 NOT NULL,
`preco_servicosalao` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
`tempo_servicosalao` int(10) unsigned DEFAULT NULL,
`descricao_servicosalao` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
`codigo_servico` int(10) unsigned NOT NULL,
PRIMARY KEY (`codigo_servicosalao`),
KEY `FK_servicosalao_1` (`email_salao`),
KEY `FK_servicosalao_2` (`codigo_servico`),
CONSTRAINT `FK_servicosalao_1` FOREIGN KEY (`email_salao`) REFERENCES `salao` (`email_salao`),
CONSTRAINT `FK_servicosalao_2` FOREIGN KEY (`codigo_servico`) REFERENCES `servico` (`codigo_servico`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_general_mysql500_ci;