Help SQL Stored Procedure

 Hello I have these tables
 
tblTransactionHeader

 
iTransactionHeaderID int
iTransactionTypeID int
tCardNo varchar(25) <------ my card no.

 dDateReloaded datetime
 
tblTransactionDetail
 
iTransactionDetailNo int
iTransactinHeaderID int
tCardNo varchar(25)  <------ card that I reloaded 
mLoadAmount money
iTransactionTypeID
 
tblTransactionType
 
 iTransactionTypeID int
tTransactionName varchar(30)
 
tblCustomer
 tCardNo varchar(25)
tLastName varchar(100)
tFirstName varchar(100) 

 
 
What I want to show is something like this... 
 
TransactionHeaderID    tTransactionName    mLoadAmount   dDat ...