× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.