|
Argh...someone smarter than me (probably all) please help me with this little SQL thing. Here's my deal: 3 files FILEA contains relationships (columns FILEA.PARENT and FILEA.CHILD), where there is a 1-N relationship between parents and children. PARENT and CHILD are SKU numbers. FILEB contains SKU numbers and identifiers (FILEB.SKU and FILEB.ID). Valid IDs are 1=Collection, 5=Set, 9=Item. Collections can contain sets and items. FILEC contains SKU numbers and descriptive information (FILEC.SKU and FILEC.DESC). What I want is to have a result set (proper term?) that has this data like this: Collection1 Set1 Set2 Collection2 Set3 Set4 Set5 . . . Item Item Item Where Set1 and Set2 are children of Collection1, Set3-Set5 are children of Collection2, etc. I would then like all the items to be after all the collection/set information. Since each entity has descriptive information, I need each result set row to have the SKU number and descriptive information. I also need things ordered by a column in FILE1. Whomever can send me an SQL statement that could make this work would be a hero, and I would be happy to answer any communication or RPG questions they have to the best of my ability. I know...I need to learn SQL better. TIA... -- michaelr_41@xxxxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 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.