table join

SELECT c.idx, c.word_t, c.class_t, c.frequency_t, c.synonyms_t, CASE WHEN a.word IS NOT NULL THEN 1 ELSE 0 END AS passed FROM vocalens_words_t c LEFT JOIN vocalens_pass a ON c.word_t = a.word WHERE c.idx>=0 and c.idx<10 https://stackoverflow.com/questions/9387839/mysql-if-not-null-then-display-1-else-display-0/9387864 MySQL IF NOT NULL, then display 1, else display 0 I'm working with a little display complication here. I'm sure there's an IF/ELSE capability I'm just overlooking.

I have 2 tables ...