I'm joining two tables, where second table consist of bit data type, which I was hoping to filter by, but cannot figure out correct syntax.
JOIN [Table2] on [Table2].ID = [Table1].ID
WHERE [Table2].Column1 = 'test'
AND [Table2].Column2 = 1
Column1 is varchar, Column2 is bit,null. It fails on Column2.