>>Hi everybody,
>>
>>I'm trying to figure out the simplest way to achieve the following.
>>
>>I have 3 different tables: People, Friends + one more table.
>>
>>I need to create a "Registration" table where I would have all fields from all these 3 tables.
>>
>>In other words, I need all the fields from these 3 tables and some of the constraints.
>>
>>Thanks a lot in advance.
>
>Too bad SQL Server doesn't have SELECT INTO clause or CREATE TABLE FROM SELECT ...
>
>The only way I can figure myself out is to manually combine 3 scripts I have on these tables...

Since I didn't figure a better way that's how I did it. But any other ideas still welcome.

Thanks again.