>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...