Re: Basic SQL Help

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

Michael,

A rudimentary shot without testing:

SELECT 'A' AS Code, a.parent, b.id, c.child, d.id
FROM fileA a, fileB b, fileA c, fileB d
WHERE (a.parent = b.sku AND b.id = 1
AND  c.child = d.sku and d.id = 5
AND  a.parent = c.parent)
UNION
SELECT 'B' AS Code a.parent, b.id, c.child, d.id
FROM fileA a, fileB b, fileA c, fileB d
WHERE (a.parent = b.sku AND b.id = 1
AND  c.child = d.sku and d.id = 9
AND  a.parent = c.parent)
ORDER BY Code, a.parent

To get the description in you have to put in fileC twice, each with a different 
alias.

In QMQRY you can create a FORM to omit the column Code and break on the column 
a.parent.

Regards,
Carel Teijgeler