|
Sorry. Now tested.
SELECT T1 as (SELECT COMPANY, WAREHOUSE, ITEM, VENDOR FROM MYTABLE)
, T2 as (SELECT ITEM, VENDOR from T1 GROUP BY ITEM, VENDOR)
, T3 as (SELECT ITEM, COUNT(*) AS NBRVENDS FROM T2
GROUP BY ITEM
HAVING COUNT(*) > 1)
SELECT * FROM T1 a
JOIN T3 b on a.ITEM = b.ITEM
Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"I get my exercise acting as a pallbearer to my friends who exercise."
-- Chauncey Depew
exampleSorry I was not clearer. I want to be able to distinguish betweenrows
where the Item is the same, but the Vendor is different, and I wantto
see a list of all the records in which this is true. From my
oftable, I would like to see all of the 256 rows (since amongst them,the
vendors are all not the same) but would not like to see any of the303
rows. And I want to see all four(4) 256 rows, even though two (2)
showthem share the same vendor.the
I have a table where my data would be like
Company Warehouse Item Vendor
1 1 256 25
2 1 256 *blanks
3 1 256 24
4 1 256 24
1 1 303 25
2 1 303 25
What I am looking to do is generate a list which will show all of
Item 256 rows (since these rows are not all the same) but not
any
of the Item 303 rows.
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.