If the tables have different collation you will get an error message if you are using regular join. You have to use the collate clause. Example:

where PO.InvoiceDetailID = Transmittal.InvoiceDetailID COLLATE SQL_Latin1_General_CP1_CI_AS