Help with query: FROM Table1 WHERE Table2.Column1

[Bro]

Hi

I have two tables. both tables contain an id column (Integer) with the same values. Table1 contains the data I want. Table2 contains one column with boolean values.

So this is what I want (though it doesn't work at all)

FROM [Table1] WHERE [Table2].[BooleanVolumn]=true

So I want all the records from Table1 where the same record in Table2 have a true value in Table2.BooleanColumn.

This is hard to explain, but I hope you understand.

Thanks for any help!

 

[Jon K]

FROM [Table1] INNER JOIN [Table2] ON [Table1].[ID] = [Table2].[ID]
WHERE [Table2].[BooleanColumn]=True;
.

 

[Bro]

Thank you very much!
Works like a charm!