How to Perform RawJoin?

[BreakPointSoftware]

Hello All,

With all the wisdom in the world, I'm locked into a database that has used . notation inside table names. for example:

[Domain.Payment]

Note that the DBA has not correctly set up schema namespace and instead opted to suffix all the tables with Domain.* notation. Unfortunately, it far too entrenched to wind back now.

This means I have been needed to use FromRaw in order to perform queries, but I'm not how sure how to do RawJoin? Is it possible?

The query I'm trying to create is:

SELECT [Domain.Payment].[Value]
     , [Domain.Payment].[Total]
     , [Domain.Payment].[Change]
     , [Domain.Payment].[TransactionID]
     , [Domain.Payment].[PaymentID]
     , [Domain.PaymentType].[PaymentTypeName]
     , [Domain.PaymentType].[PaymentTypeFunctionKeyID]
    FROM [Domain.Payment]
             LEFT JOIN [Domain.PaymentType] ON [Domain.Payment].[PaymentTypeID] = [Domain.PaymentType].[PaymentTypeID]
             RIGHT JOIN [Domain.Transaction] ON [Domain.Payment].[TransactionID] = [Domain.Transaction].[TransactionID]
    WHERE [Domain.Transaction].[ZReportID] = @ZReportID;

[generik0]

Close?