Update All Fields and Wild Cards

[firefly2k8]

Can anyone see what is wrong with this:

UPDATE Excluded_Trades 
INNER JOIN Project_Table 
SET Excluded_Trades.* =  Project_Table.* 
WHERE  Project_Table.Project_ID = 276;

If I can't use wild cards, how would I do this?

I should add that Excluded_Trades has the same table structure as Project_Table

 

[jdraw]

It would appear you have 2 tables with exactly the same fields, and you are trying o set all the values of all the fields to be equal.
Why would you have 2 tables the same in your database.
Why not just use a make table query if it is really needed?

 

[firefly2k8]

I want to permantently store all records from my Project_Table into a table called Excluded_Trades where the Project_ID field of Project_Table is equal to 276.

My next operation is to delete these records from Project_Table