Re: Join and Not Equal to results
I appreciate the response. I made changes and I'm getting this error.
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 't2. FROM 'Orders01' JOIN 'Orders02' ON t2.OrderNumber = t1.OrderNumber AND t' at line 1
SELECT t1.,t2.
FROM 'Orders01' t1
INNER JOIN 'Orders02' t2 ON
t2.OrderNumber = t1.OrderNumber
AND t2.LineItemName = t1.LineItemName
AND t2.LineItemQuantity <> t1.LineItemQuantity
Subject
Written By
Posted
February 03, 2017 08:06AM
February 03, 2017 02:15PM
Re: Join and Not Equal to results
February 07, 2017 07:26AM
February 08, 2017 02:56PM
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.