im trying to select some data from 2 tables, where i left join the info in table2, where t2.name = "x"
so ive got the following but it just doesnt work?
select t1.ent, t2.priv
from file.csv t1
left join file2.csv t2
on t1.ent = t2.ent
where t2.app = 'x'
it does all work until i add in the final where clause and then the results are empty
but i know that t2.app = "x" does exist