|
Re: Report Results Not As Expected
2001-08-22 14:35:23
|
Subject: |
Re: Report Results Not As Expected |
|
From: |
"PINNI, BALANAND (SBCSI)" <bp3965 AT SBC DOT COM> |
|
Date: |
Wed, 22 Aug 2001 13:36:36 -0500 |
I understand that u are using 3 aliases for 3 tables with join statements
for SQL.
I do remember as when u make equi join statements we have to make proper
comparison
i,e after WHERE statement.
Else for each record to be displayed it matches with all the records from
source table
,here in ur case it seams to be 3.Hence 3 times it displays.
This has been defined as some term in Oracle or SQL .
U can go to oracle web site with url get info on that.
http://technet.oracle.com/doc/oracle8i_816/appdev.816/a76939/adg01dev.htm
Balanand Pinni
|
|
|
