Building a query text depending on DCS parameters

Hello! I am building a report using Data composition schema, and it should contain different data sources depending on the query parameters. When I need to filter by some attribute I use WHERE clause, but when I need to get data fr om different tabular sections I'm a little confused. How can I make a query wh ere data should be obtained from different tabular sections of catalog depending on DCS parameter value?

Hi, Nobuyuki Susumu!
You can work with tabular sections as with ordinary tables, for example if you need all data of ContactInformation tabular section of Companies catalog for specific company, you need to use the following query:

SEL ECT * 
FR OM Catalog.Companies.ContactInformation AS ContactInformation 
WHERE ContactInformation.Ref = &Company

I see, thank you, Xin Wang!
So, I've solved my problem using UNION clause and adding conditions for rows in the following way:

SELECT 
    KitContent.Item, KitContent.Quantity 
FROM Catalog.Items.KitContent AS KitContent 
WHERE &UseKits
UNION ALL
SELECT 
    BOM.Item, BOM.Quantity 
FROM Catalog.Items.BOM AS BOM 
WHERE &UseBOMs

You can try to use report variants for separate your scopes