All Forums General
C McKeever 1 post Joined 05/16
25 May 2016
Teradata Driver 15 Issue in Microsoft Access

I am experiencing and issue running a query against Teradata database tables using an outer join in Microsoft Access.  The query works with a simple join but not an outer join.  We recently upgraded to Teradata 15.10 (upgraded drivers too).  I'm wondering if anyone has experienced this and how they were able to correct it. 
It is a very basic query:
Select T1.Field1
From T1 LEFT OUTER JOIN T2
ON T1.Field2 = T2.Field2
GROUP BY T1.Field1
Any thoughts/suggestions are greatly appreciated.
Thanks,
C McKeever

dnoeth 4628 posts Joined 11/04
26 May 2016

Can you show your actual query?
Your Select is the same as SELECT DISTINCT Field1 From T1
And what do you mean by issue, error message, wrong result?

 

Dieter

You must sign in to leave a comment.