creating a junction table
can anyone please give me some idea about the following issue?
i have a customers table, and user table.
in customers table i have-- custid,firname,lastname etc
users table -- id,username,password
i want to join these two, so that, i get the custid for future use
so that when the user should be able to login with username and password, and the remaining all informations should get based on the custid
how can i do this?