i have a problem

[Matar]

hi how i can retreve a data form two related tables ?i have 2 tables 1 - users table : this table contains the username and password for the users 2 - data table : this table conatins an addtional data about the user .so how i can make a connection to the user table after that the script dedected the data from the data table ???

[lordfa9]

hmm i tried using inner join once for my SQL statement once but it didn't really work.Maybe you are better off combining the two tables together?

[justsomeguy]

You can use a join. Say you have users table, that has a userID field, and the data table also has a userID field. You can do something like this:SELECT * FROM users, data WHERE users.userID='someuser' and users.userID=data.userIDIf the tables have fields with the same name, you will need to do some more specifying (instead of SELECT *) to get the fields you want, and maybe get them with unique names. Like this:SELECT users.field1 as userfield1, data.field1 as datafield1 ...etc