Help with a three table join

Help with a three table join

  
I have an entity called "Products" that has the fields ProductId, Name.

I have an entity called "Services" that has fields id, ServiceName, ProductId where ProductId is a foreign key for the "Products" table.

I have an entity called "ComponentUses" that has fields id, ComponentId, ServiceName where ServiceName is a foreign key for the "Services" table

I have an entity called "Components" that has the fields ComponentId,ComponentName,Version,Status.  ComponentId is the primary key.

They look like the following:

Products
1,Search

Services
5,Indexing,1
3,Web,1

ComponentUses
1,1,5
2,2,5
3,7,3
4,9,3

Components
1,Index Service,1.2,Online
2,Index Database,3,Online
7,HTTP,2.2.3,Offline
9,Sign-On,1.5-3,Online

How do I configure an Advanced Query so that it returns the following table that is displayed on the Product_Show web page for the Products entity:

ServiceName,ComponentName,Version,Status

Thanks!

Craig
Hi Craig,

You can do the query using a simple query instead of an advanced query as you had mentioned. See the image bellow.



As output of that query you will have the following:



I hope I've helped,
 
Regards,
Nelson Baptista