How to select rows that date is in range from ranges table I have a table1 that hold ranges

rangeId, rangeName, fromDate, toDate,cat


another table2 has rows 

rowTitle,rowDate


I need to 

select  all rows
from table2
that table2.rowDate is between table1.fromDate
                           and table1.toDate
and cat = 1
Something like :

select t2.*
from table2 t2
join table1 t1 on t2.rowdate between t1.fromDate and t1.toDate
where t1.cat = 1