hi all

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?

thanks

create table customer_jct
(custjctID int identity (1,1)primary key clustered,custID int,id int)
IF you do not have relationship between the two table you will have to assign and create a temp table to aligh your records

Jaime E. Maccou