P pdbowling Registered User. Local time Today, 17:56 Joined Feb 14, 2003 Messages 179 Dec 19, 2003 #1 Unfamiliar query symbo... Hello all, I ran across this 'Where clause' and didn't recognize one of the symbols WHERE MAXIMO.V_INVENTORY.ITEMNUM (+) = MAXIMO.V_POLINE.ITEMNUM What is (+)= doing? Thanks all PB
Unfamiliar query symbo... Hello all, I ran across this 'Where clause' and didn't recognize one of the symbols WHERE MAXIMO.V_INVENTORY.ITEMNUM (+) = MAXIMO.V_POLINE.ITEMNUM What is (+)= doing? Thanks all PB
W WayneRyan AWF VIP Local time Today, 17:56 Joined Nov 19, 2002 Messages 7,120 Dec 20, 2003 #2 pd, That is from an ORACLE system I bet. It means include ALL from the V_INVENTORY table and if there is no corresponding entry in the MAXIMO table, put blanks. Wayne
pd, That is from an ORACLE system I bet. It means include ALL from the V_INVENTORY table and if there is no corresponding entry in the MAXIMO table, put blanks. Wayne
P pdbowling Registered User. Local time Today, 17:56 Joined Feb 14, 2003 Messages 179 Dec 22, 2003 #3 Thank you Ah, yes it is Oracle. Thank you. Makes sense. PB
N namliam The Mailman - AWF VIP Local time Today, 18:56 Joined Aug 11, 2003 Messages 11,685 Dec 22, 2003 #4 Did i not make a reaction to the same question somewhere or other??? Strange, but i see.... You double posted the *Blieping* question Bad you ! Last edited: Dec 22, 2003
Did i not make a reaction to the same question somewhere or other??? Strange, but i see.... You double posted the *Blieping* question Bad you !
P pdbowling Registered User. Local time Today, 17:56 Joined Feb 14, 2003 Messages 179 Dec 22, 2003 #5 Crosspost Sorry about the cross/double post, namliam. Not sure what happened. PB
