I have 2 tables
table_A with id, name, customer_id, sales_channel_id
table_B with id, table_a_id, product_id, date
I want to search in table_B with conditions table_A.customer_id = :customer_id And table_A.sales_channel_id=:sales_channel_id and table_B.product_id=:product_id
How to do this search with DAL in shopware 6?