Left join with multiple conditions

chipaldance

Hi Allan,

I have to make left join with 2 conditions like :
SELECT *
FROM programmes
LEFT JOIN programmes_t ON programmes.t_id = programmes_t.tt_t_id
AND programmes_t.tt_cen_id =2
WHERE 1

I read on old topics from 2014 that this is impossible.
Do you have a solution today ?

In this topics, your solution is a request like :
SELECT *
FROM programmes
LEFT JOIN programmes_t ON programmes.t_id = programmes_t.tt_t_id
WHERE programmes_t.tt_cen_id =2

But this is not the same, and this solution doesn't work for me. Do you have another solution ?

Thanks,
Gaétan

allan

This thread contains a discussion about how this can be done with Editor using the PHP libraries that it comes with.

Allan