Norwichhat wrote:
> I am having alot of SQL trouble with this can someone tell me how to join it i am having the same problem

Read this first: http://www.w3schools.com/Sql/sql_join.asp

Then post what you have tried in a new post and then we will see if we
can .

Steve