|
Subject:
|
creating a junction table
|
|
Posted By:
|
sarah lee
|
Post Date:
|
1/9/2007 9:12:25 PM
|
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
|
|
Reply By:
|
jemacc
|
Reply Date:
|
1/10/2007 4:18:24 PM
|
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
|
|
