Jump to content

left join doesn't work


Recommended Posts

Hi, pplI got a littler prob, I just I just wonna do a simple query .... pls .. see what's wrong in that..Select id, DATA_DtClaTurSal.codEns, DATA_DtClaTurSal.CodCur, desSLC, codEdificio, DesClas, DesEns, DesCur from GE_SLC, COD_Ensi, COD_Clas, DATA_DtClaTurSal left join COD_Curs on DATA_DtClaTurSal.CodCur = COD_Curs.CodCur where Turno = 0 order by id, DATA_DtClaTurSal.codEns, codEdificio;

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...