Query to update a table

[Brian T]

I have a table with a project number in it and would like to insert that into
rows of another table.

Thanks

 

[orange]

I have a table with a project number in it and would like to insert that into
rows of another table.

Thanks

One project number to go into all rows of the other table?

Here's a link that describes the syntax of the UPDATE statement

http://www.w3schools.com/SQl/sql_update.asp

 

[KARL DEWEY]

insert that into rows of another table.
How many row?
How to determine which project number to insert?
Is that all that the new records will conntain?