Oracle 9i added SQL 1999 support, which includes OUTER JOIN.
In SQL 92 syntax the where clause can have both the join
relationships and filter conditions. In SQL 1999 syntax
the where clause only contains filter conditions.
Note: Oracle 9i allows both SQL92 and SQL 1999 syntax to
peacefully coexis
I run the query and it run even though in Rapid SQL send the
next error:
unexpected token:LEFT
My questions is what is the difference between
where an join in Oracle, what is better and
why?
>>> [EMAIL PROTECTED] 07/02/03 06:55PM
>>>
Hi !!
(I am using Oracle 9.2)
I am trying to run the n
Hi !!
(I am using Oracle 9.2)
I am trying to run the next query but I received an error in
the from statement.
SELECT POLINE.ITEM AS
CVEART,
POLINESRC.QUANTITY
AS CANT_PE,
ROUND( ITEMLOC.SOH_QTY - (
ITEMLOC.ALLOC_QTY + ITEMLOC.IN_PROC_QTY), 2) AS EXIS_BOD,
CASE WHEN POL
: SQL statement problem - outer join where?
>
>
> Hi,
>
> I'm facing a bit of an struggle with this SQL statement. The one below
> results in the correct number of records (601). However, when
> I add the
> tables ITEM_C (Customer Part Number) using CUST_NUM and ITEM
Hi,
I'm facing a bit of an struggle with this SQL statement. The one below
results in the correct number of records (601). However, when I add the
tables ITEM_C (Customer Part Number) using CUST_NUM and ITEM_NUM I get
fewer records (526). The reason is because there are item numbers which
do not h
