![]() |
Normally when I build a query with LEFT JOINs I have a previously mentioned table on the left side of the equal the table in the LEFT JOIN on the right side of it. In analyzing queries that a 3rd party app is executing I see something like the following:
22 Apr 2016
| 1 comment
,
|
![]() |
Hi,
18 Mar 2015
| 1 comment
,
|
![]() |
Hello Guru's,
18 Nov 2014
| 5 comments
,
|
![]() |
Hello -
02 Jul 2014
| 3 comments
,
|
![]() |
Can anybody please explain how nested joins work in Teradata???
28 Dec 2013
| 1 comment
,
|
![]() |
The presentation is to acquaint business users with Structured Query Language (SQL) and some interesting techniques to access their data with examples for using CASE; Subqueries and Correlated Subqueries; Types of SQL joins and how they are implemented on Teradata; facts about NULLs; Derived Table usage and other interesting optimizer information.
11 Oct 2013
,
|
![]() |
Background:
25 Jan 2013
,
|
![]() |
Hi,
06 Nov 2012
| 5 comments
,
|
![]() |
hi All I m using V12,
24 Dec 2010
| 1 comment
,
|
![]() |
I've had some problems with joining to a concatenated variable and although I've fixed the problem I'd like to understand what happened here. As background, in a transaction table we have the first digit of the account number was dropped for a couple of days and so we have a number of records where the account number needs a single digit added to the front. We basically wanted to do a really simple query to find out how many transactions have been made on an account. However, when a join on the reconstructed account number didn't work. The abstraction of the code is below:
08 Aug 2010
| 1 comment
,
|
![]() |
Hi, I am new to Terra Data. I have complex queries that are retrieving data from different tables and using different joins. Also, i have to apply some conditions to clean the duplicates and time period checks.
19 Feb 2010
| 1 comment
,
|