how to fill a table with using some of the data of other tables

I need to create a new table called “customer” that include some of columns from the “user t开发者_运维知识库able”, and also “project table”. I built my suppliers table with specific column names and I need to fill its column by using data of the other tables. Finally I am trying to finish; when user create a new account and project, the customer table automatically fill with some of other two tables varieties with different column names.

INFO: I have three different user types such as “suppliers”, “costumers”, “managers”. I am holding their information(include user types) in one table called users.

Use the following query as an example and write a query to insert the rows to destination table from source table. Ex:-

INSERT INTO TestTable (FirstName, LastName)
SELECT FirstName, LastName
FROM Person.Contact
WHERE EmailPromotion = 2

Note: Use Join in the select query to join two tables

The 1st step would be to couple the data from the different tables using a table join command. If you can create a search result that matched your new table, then creating the table is simple a call to the below.

Create table CUSTOMER as (Select ...)

"when user create a new account and project.." this is something you plan on doing at run time in your application and not something you need to collate using sql at this point?