Link 2 tables without a join when table 2 returns 0 rows

See more:

SQL

SQL-Server

I have 2 tables T1 and T2

I want to link them based on a common field eg TranxID

My condition is if T1.TranxID does not exist on T2 then return the row with a NUll or '' T2.TranxID

Else if T1.TranxID exist on T2 then return row with TranxID

What I have tried:

select OrderNumber, TransactionStatusId,FuelPointGuid,B.InvoiceNo,*
from svc_ilfms_live.dbo.FuelTransaction F
	LEFT JOIN IBS_Platform_Billing_Live.dbo.Billing B ON F.Id = B.TransactionId
	where F.orderNumber like '%KWS%'
	AND F.TransactionDateTime BETWEEN convert(varchar, getdate()-60, 23)+' 00:00:00' AND convert(varchar, getdate(), 23)+' 23:59:59' 
	    AND F.FileSent = 0
	order by F.TransactionDateTime desc