i have 1-N Link.How to call it in query def select condition

Hello @shrutii ,
you can do it two ways:
Exist such as

• In query condition select (advanced fields, ... on bottom page, if the links are not shown)
• find your link and double click on it
• it will create condition exits such as
• create condition

Filtering dimension

• In query activity you can select targeting dimension and filtering dimension
• if the link is configured correctly you should see the linked table in the filtering dimension select
• create condition to filter you target data

First option has lower performance is recommended to use filtering dimension for linked tables

Marcel 

can you PLEASE SEDN SAMPLE CODE PLEASE

lets consider t

able1 has a,b,c columns--

and table 2 has d,e,f columns

and both table1 have 1 to N link with table2

please help

@shrutii ,

You can call it in a SQL query using a JOIN statement. Here's an example:

Suppose you have two tables: customers and orders.

The customers table has columns customer_id, first_name, and last_name. The orders table has columns order_id, customer_id, order_date, and total_amount.

To select all orders for a specific customer, you can use the following SQL query:

SELECT orders.order_id, orders.order_date, orders.total_amount

FROM orders

JOIN customers ON orders.customer_id = customers.customer_id

WHERE customers.first_name = 'Shruti' AND customers.last_name = 'Abc';

This query selects the order_id, order_date, and total_amount columns from the orders table and joins the customers table on the customer_id column.

The WHERE clause filters the results to only include orders for a customer with the first name ‘Shruti’ and the last name "Abc". You can modify the WHERE clause to search for a different customer or use other conditions to filter the results based on your specific needs.