You can use view or sp in mssql to get data from multiple tables.