Update if row exists otherwise add row from another table if equal to status

[SQLrookie01]

Hi,

I'm using SQL server and I'm trying to create a script to update my table if row exists, else insert into that table.
Let's call the table I want to add rows into SALES and my other PROJECT
Will always be a one-one relationship.

If a new project comes in, I want to create a SQL statement that checks if that project exists, if it does it should update a few columns of my sales table, but if it does not exists then add that record into my SALES table.

I have ProjectID, Client and Status in both tables.
I have tried something like this, but not gotten it right.

IF EXISTS (SELECT 1 FROM SALES INNER JOIN PROJECT
ON (SALES.ProjectID = PROJECT.ProjectID 
AND
SALES.Status = PROJECT.Status))
        BEGIN 
            UPDATE SALES(ProjectID, Client, Status)
        END
 ELSE
        BEGIN
         INSERT INTO SALES(ProjectID, Client, Status)
    Select ProjectID, Client, Status
    from PROJECT
    Where Status = 'Active' or Status = 'Expected' or ProjectType = 'Confirmed'
       END

Any suggestions on how to solve this?

Thank you very much!

[NeoPa]

It seems to me that you may be looking for the MERGE (Transact-SQL) statement.

To assist in your searching it may help to know this is also frequently referred to as UPSERT (Update / Insert) in general parlance.