SELECT Investors.InvestorID, AllocationID, FName, LName, Street, City, State, Zip, AreaCode, Phone
FROM dbo.Investors INNER JOIN dbo.Trades
ON dbo.Investors.InvestorID = dbo.Trades.InvestorID
Microsoft SQL Server - SQL Database - Trade Allocation by Investor - SQL Query With Inner Join