goodmood_ch
-
Posts
2 -
Joined
-
Last visited
Never
goodmood_ch's Achievements
Newbie (1/5)
0
Reputation
-
Outer join with multiple tables - not working
goodmood_ch replied to goodmood_ch's topic in MySQL Help
works fine, thanks a lot ! -
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