Okie I have three tables.
1) for 'users' (UserID, Address, FirstName, LastName, Email,UserName, Password, UserLevel,Regdate)
2) for 'statement (StatementID, MonthID)
3) for 'tom_sawyer_db' (UserID, MonthID, TransacID,DateID,TransacName,Deposits,Withdrawal,Balance)
I would like to know how to link them up to get a table with
Date, Transaction, Deposits,Withdrawal, Balance for a month at a time for a user at time.
I have numerous users tom_sawyer_db is one of them. So after tom sawyer logs in, he will get to choose a monthly statement to display a table with his statements, and when clicked e will see only month of his statement data. I use dreamweaver so if you have an sql code how to link these tables please let me know.
Edited by sundeep.gurroby: errors