sql

Kar hoces iz d tabele daj v where, drugace pa povej kaj sploh hoces. Ce hoces 101 in 102 dobit ne rabis nic povezovat ampak uporabi IN

Select a.term, b.term
From tabela a
Left outer join tabela b on b.term = a.term and b.id_master = 102
where a.id_master = 101

Lohk da sm se kje zatipku. A si to hotel?

tole deluje:

SELECT d.term,d1.term 
from tabela d
left JOIN tabela d1 ON d.term = d1.term and d.id_master = 101  and   d1.id_master = 102
where d.id_master = 101

Nimam pojma, sem na SQL fiddle spremenil v mysql 5.6 pa dela kot pri tebi.
na moji, neki stari 5.1.59-community-log, pa ne.

Ah, pardon, dela, 1000 stvari naenkrat (-:

a te null jebe?

pazi zdaj. AKO! narediš left join in potem v where daš table1.primarykey = somethinhg and table2.primaryKey = something s tem dejansko narediš inner join!
moral bi dati (table2.primarykey = something or table2. primarykey is null)
ali pa and iz where premakneš v left join, kakor si sam pogruntal.