I have a table where there are items in which there is a relation of parent and child. By this I mean that a product, like CASE of Coor's is the parent of the products of 6pk Coor's and 1 can Coor's (see attached).
To make the relationship between the Parent/Child, if the column "ChildParentRelate" has a value, that measn the that item has a parent. The vakue is the ID of the parent.
What need a query to display the child items only if the item being read has a child, as in the example Coors and Bud (see attached). The rest of the items has no child, it displayed as they are.
In the attachment, the first part displays the database table content, the second part display expected script results