Topic: Sql запрос
мне нужно
из client взять firstNameClient lastNameClient
из servise взять dateApplcation
где servise.id_clCompanyOrApp =3
ВОТ К ЧЕМУ Я ПРИШЁЛ
SELECT
client.firstNameClient,
client.lastNameClient,
servise.dateApplcation
FROM
servise
LEFT OUTER JOIN firstNameClient ON client.id=servise.id_client
LEFT OUTER JOIN lastNameClient ON client.id=servise.id_client
LEFT OUTER JOIN dateApplcation ON client.id=servise.id_client
WHERE servise.id_clCompanyOrApp=3