Hello,
The most important tables in this query are \"ticket\" and \"employes\"
\"ticket\" as an idEmploye (to retrieve the coresponding employe), which can be null
I want to list the tickets for all idEmployees ( where null and not null)
Here is the query
$sql = "SELECT T.idTicket, T.titreTicket , T.dateOuverture, E.nomEtatTicket, T.idEtatTicket, EM.userNameEmpl, T.ouvertPar ";
$sql .="FROM tickets T, etatsTickets E, employes EM ";
$sql .="WHERE T.idEtatTicket IN (1,2,3) ";
$sql .="AND T.idProjet = $idProjet ";
$sql .="AND E.idEtatTicket = T.idEtatTicket ";
$sql .="AND T.idEmploye *= EM.idEmploye ";
<-- Dont know how to make this outer join with mysql
Thanks for your answers