How to set a primary key field when I select from several joins into a new table?
Posted on 2008-10-22
Hi, I have the following selects. How can I set the Id field to be a Primary key but not auto-increment? Thank you.
,D.[Membership Reason 1]
,E.[Membership Service Requirement 1]
FROM dbo.TempApplication2 a
FULL JOIN dbo.Degree C on a.Id = C.ApplicationId
FULL JOIN dbo.Reasons D on a.Id = D.ApplicationId
FULL JOIN dbo.Requirement E on a.Id = E.ApplicationId
ORDER BY a.Id