How to create a stored procedure with columns from three different tables in SQL Server 2008?
SELECT 
    C.customername 
    ,C.customercode
    ,L.[loan type] 
    ,S.[account number]
    ,S.status
FROM
    [first table] AS C
    INNER JOIN [second table] AS L
    ON C.customercode = L.customercode
    INNER JOIN  [3rd table] AS S
    ON S.customercode = C.customercode


This is only as a guidance; it is better to post some sample data and definitions.