How to delete from table in case of code type have value or not ?

See more:

SQL

stored-procedure

How to delete from table in case of code type have value ?

I have temp table #temppc

I need when codetype on temp table #tempPc not have null meaning have value

then

delete statement from table Parts.TradeCodes will be

DELETE TCC FROM #TempPC t INNER JOIN Parts.TradeCodes TCC ON t.ZPLID=TCC.ZPLID and t.CodeType=TCC.codeType

and if codetype on temp table #TempPc is null then delete statment from table Parts.TradeCodes will not have codetype

and it will be

DELETE TCC FROM #TempPC t INNER JOIN Parts.TradeCodes TCC ON t.ZPLID=TCC.ZPLID

so How to modify delete statment on query below that to delete based on two cases if codetype have value or not

What I have tried:

How to modify delete statment below to delete if code type have value or not
if code type have value then and t.codetype=tcc.codetype
if not
it will be as below

DELETE TCC FROM #TempPC t INNER JOIN Parts.TradeCodes TCC ON t.ZPLID=TCC.ZPLID

create table #TempPC 
(
[ID] INT IDENTITY,
ZPLID INT,
CodeType int

)

DELETE TCC FROM #TempPC t INNER JOIN Parts.TradeCodes TCC ON t.ZPLID=TCC.ZPLID