[SOLVED] New to joins

[dare87]

I have a two tables, one is loanapps and the other is team.

 

I want to make it so when I run the query it has the persons name and not there team_id

 

("SELECT first_name, last_name, dob, ssn, co_first_name, co_last_name, co_dob, co_ssn, email, phone, wphone, cphone, time, contact, address, city, state, zip, income, co_income, vemployment, vincome, vassets, hear, refer, hearother, purpose, purposeother, ifpurchase, refibuy, loanamount, currentmortgage, secondmortgage, loantype, propertytype, propertyuse, value, propertystate, revolving, installments, otherpymts, credit, comments, DATE_FORMAT(date_entered, '%m/%d/%y') AS date FROM loanapps ORDER BY date_entered ASC");

 

refer = team_id

 

but I want it to equail name where team_id in the team table.

 

Thanks

 

also I need to hide/protect the ssn numbers what is the best way to do that?

[mwasif]

Do no include ssn in SELECT, and use INNER JOIN to join the tables. It will be better if you post boht tables structure.