[adubb]

I have 2 tables

login and member

the login table has

ID, username, password, type

the other one holds the information of a user

So like...

ID, firstname, lastname, address, login_id

I want to query so that i can display all the members and their info

My current query is this:

SELECT DISTINCT(lo.ID),lo.username, me.F_name, me.L_name, me.Address, me.Email, me.Phone, me.reg_date, me.payment_date, me.STATUS FROM login lo,member me WHERE lo.type = '1'  GROUP BY lo.ID 

but it seems like its pulling up the information from only one of the members info, for every ID in the login table

what would be the proper way to join this?

[UnrealEd]

like you said: use a JOIN syntax :

SELECT * FROM login lo JOIN member me WHERE me.ID=lo.ID 

i haven't tested it, but it should work

cheers

[adubb]

You are the man with the PLAN, I was way over my head in that one. Thank-you much appreciated.