I used the "Create Database View" in ArcToolbox and it successfully created the table view, but it still didn't show any records, just column headers. I can see records in the individual tables but when I create the view of them combined, I don't see anything. The records can be seen on the SQL Server side though.