Piocota Posted November 5, 2007 Share Posted November 5, 2007 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 More sharing options...
justsomeguy Posted November 5, 2007 Share Posted November 5, 2007 So you're doing an inner join on 4 tables and then you want to do a left join between those 4 tables and another table? Link to comment Share on other sites More sharing options...
Piocota Posted November 13, 2007 Author Share Posted November 13, 2007 justsomeguyTHNKS for y'allI discovered where was the mistake.I think the sql query doesn't accept a join on 4 tables at one time, i had to make that one (join) at time, now it's working.Note: my english isn't to good. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.