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.
|
General | Welcome to the Teradata Forums.
Read the
guidelines on posting.
Email notifications and RSS feeds are available, and also a chronological list of all forum activity. |
|
|
Active Posters
|
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