Information générale
Catégorie:
Codage, syntaxe et commandes
>>select * ;
>>from thetable A, thetable B;
>>where a.groupnum <> b.groupnum and;
>>a.itemnum = b.itemnum and;
>>a.quantity <> b.quantity
>Also, my problem wasn't quite as simple as I said. There are really more than two groupnums, so I made a query that selects WHERE groupnum = 1 OR groupnum = 2 and then ran your query off that cursor. Perhaps I could have merged them into one cursor, but this way seemed easiest.
Yup. You can just add the condition to the above query that
(a.groupnum = 1 or a.groupnum = 2)
Self joins are quite powerful. Glad I could help.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement