Re: Join and Not Equal to results
So I got this to work...
SELECT Orders01.name, 'Lineitem quantity'
FROM Orders01
INNER JOIN Orders02
ON Orders01.name = Orders02.name
and Orders01.`Lineitem name` = Orders02.`Lineitem name`
and Orders01.`Lineitem quantity` <> Orders02.`Lineitem quantity`
but... the actual quantities are not showing. Also, when I added LineItem SKU so that I could see the sku number, it gives me this error.
"#1052 - Column 'Lineitem name' in field list is ambiguous"
SELECT Orders01.Name, 'Lineitem sku', `Lineitem name`
FROM Orders01
INNER JOIN Orders02
ON Orders01.name = Orders02.name
and Orders02.`Lineitem sku` = Orders01.`Lineitem sku`
and Orders02.`Lineitem name` = Orders01.`Lineitem name`
and Orders02.`Lineitem quantity` <> Orders01.`Lineitem quantity`
Subject
Written By
Posted
February 03, 2017 08:06AM
February 03, 2017 02:15PM
February 07, 2017 07:26AM
February 08, 2017 02:56PM
Re: Join and Not Equal to results
February 08, 2017 02:33PM
February 09, 2017 12:07PM
February 09, 2017 12:47PM
February 09, 2017 01:44PM
February 09, 2017 02:14PM
February 09, 2017 02:43PM
February 09, 2017 03:14PM
February 10, 2017 12:45AM
February 10, 2017 12:10PM
February 10, 2017 12:30PM
February 10, 2017 01:06PM
February 10, 2017 03:41PM
February 14, 2017 09:01AM
February 16, 2017 08:39AM
February 16, 2017 10:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.