MS SQL Need help returning information where value from Table A falls between a date range in table B : Table A Transaction details
TTime (datetime), TableAValues, TableAValues, <etc>...

Table B Related table
ID, DateTimeStart (datetime), DateTimeEnd (datetime), TableBValues, TableBValues, <etc>...

I need a way to return a row of information which includes All TableAValues as well as all TableBValues where TTime Table A falls between DateTimeStart and DateTimeEnd of table B. 
