Consulta CNAE

[Former Member]

Olá a todos!

Pessoal, estou com dificuldade de inserir a coluna CNAE nesta consulta.

Alguém poderia me dar uma orientação?

SELECT T0.CardCode, T0.CardName, T0.GroupCode, T2.GroupName, T0.State2, T1.TaxId0 AS 'CNPJ', T1.TaxId4 AS 'CPF', T1.TaxId1 AS 'IE'

FROM OCRD T0

INNER JOIN CRD7 T1 ON T0.CardCode = T1.CardCode

INNER JOIN OCRG T2 ON T0.GroupCode = T2.GroupCode

WHERE T1.AddrType = 'S' AND T1.Address > ''

Desde já agradeço!

[Former Member · Accepted solution]

Consegui fazer a consulta.

Segue caso alguém precise:

SELECT T0.CardCode, T0.CardName, T0.GroupCode, T2.GroupName, T0.State2, T3.CNAECode "CNAE", T1.TaxId0 AS 'CNPJ', T1.TaxId4 AS 'CPF', T1.TaxId1 AS 'IE'

FROM OCRD T0

INNER JOIN CRD7 T1 ON T0.CardCode = T1.CardCode

INNER JOIN OCRG T2 ON T0.GroupCode = T2.GroupCode

LEFT JOIN OCNA T3 ON T1.CNAEId = T3.AbsId

WHERE T1.AddrType = 'S' AND T1.Address > ''

[Former Member]

Olá Erikson Nascimento,

Segue consulta:

SELECT T0.CardCode, T0.CardName, T0.GroupCode, T2.GroupName, T0.State2, T3.CNAECode "CNAE", T1.TaxId0 AS 'CNPJ', T1.TaxId4 AS 'CPF', T1.TaxId1 AS 'IE'

FROM OCRD T0

INNER JOIN CRD7 T1 ON T0.CardCode = T1.CardCode

INNER JOIN OCRG T2 ON T0.GroupCode = T2.GroupCode

INNER JOIN OCNA T3 ON T1.CNAEId = T3.AbsId

WHERE T1.AddrType = 'S' AND T1.Address > ''

Att
Everton Silva

[Former Member]

Obrigado, Everton, mas sua consulta retornou somente os cadastros com CNAE. Preciso visualizar todos os cadastros  de clientes, preenchidos ou não com o dado.