Join tables | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Join tables

Can I join (actual join 2 columns) 2 tables from 2 different datasets in RS
or do I have to create a SP outside of RS then use the SP in RS? If this can be done please explain. thank you