Need help with a join in SQL I am a newbie. What is wrong with this query?

Transact-SQL
1

select t.AccountId,
t.ReceiptType,
t.BatchID,
Case
when t.printshop = 'ImpressionsDirect' then b.OutsourcedMailedUTC
when t.printshop = 'LHM' then b.InternalMailedUTC
else NULL
End as HistoryDate
from receipts.PrintBatchTransactions t join receipts.printbatch b on b.PrintBatchId
where t.PrintBatchId = 'P181011.130439'
order by
t.ReceiptType

2
Error

image
image.png1766×941 67.6 KB

should be
on b.printbatchid = t.somecolumnhere

3

Thank you that worked