cancel
Showing results for 
Search instead for 
Did you mean: 

Padrão de inner join entre tabelas de banco de dados diferentes no visual studio

0 Kudos

Boa Tarde a todos, essa query funciona bem, o problema é que quando eu tento executar no visual studio da erro, alguem sabe se exixte algum padrão de inner join de banco de dados diferentes no visual studio?

var consulta = $"SELECT DISTINCT '' as [Sel.], PV.[BillingStatus] as [Status do Faturamento], T0.[DocEntry] as [Pedido sap]," +

$" T0.[CardCode] as [COD. PN], T0.[CardName] as [CLIENTE], T0.[BPLId] as [Filial], T1.[TaxId0] as [Cnpj], T2.[OcrCode2] as [Planta]," +

$" PV.[vendor] as [Vendor Cliente], PV.[Project] as [Fase do Projeto], T0.[DocDate] as [Data Lançamento],T0.[DocDueDate] as [Dia do vencimento]," +

$" T2.[ItemCode] as [Item SAP], T2.[Dscription] as [Descrição Item SAP], T2.[Quantity] as [qtd], T2.[Price] as [Valor unitário],T2.[Usage] as [UTILIZAÇÃO SAP], " +

$" T2.[TaxCode] as [Código de imposto], T2.[CFOPCode] as [CFOP], T2.[OcrCode] as [Regra de distribuição], PV.[Opportunity] as [Contrato/oportunidade], PV.[PoNumber] as [Numero da PO]," +

$" PV.[MonthlyFeeUSD] as [Mensalidade em USD], PV.[PtaxUSD] as [Dolar PTAX], PV.[MonthlyFeeBRL] as [Mensalidade em BRL], PV.[SendUntil] as [Enviar eté:], PV.[CircuitVelocity] as [Velovidade do Circuito], PV.[Kw] as [Kw]," +

$" PV.[ProRataValue] as [Valor PRO RATA], pv.[Adjustments] as [Outros Ajustes], T0.[Email] as [Enviar Cobrança Para:], T2.[FreeTxt] as [Obs. de Abertura],T2.[FreeTxt] as [Obs. de Encerramento], PV.[InvoiceType] as [Tipo da NF]," +

$" T0.[DocTotal] as [Valor Total a Faturar] FROM SBO_DATACENT.dbo.ORDR T0 INNER JOIN SBO_DATACENT.dbo.RDR12 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN SBO_DATACENT.dbo.RDR1 T2 ON T0.[DocEntry] = T2.[DocEntry] LEFT JOIN SBOApiSFDb.dbo.DCBilling as PV on PV.[OrderKey] = T0.[DocEntry] WHERE T0.[DocStatus] = 'O'";

Accepted Solutions (0)

Answers (0)