# How to write Join condition with DAL search in shopware 6?

**URL:** <https://forum.shopware.com/t/how-to-write-join-condition-with-dal-search-in-shopware-6/63743>\
**Category:** Programming (EN)\
**Created:** [30. Dezember 2019 um 12:48 UTC](https://forum.shopware.com/t/how-to-write-join-condition-with-dal-search-in-shopware-6/63743 "2019-12-30T12:48:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![abinjohnedamana](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/abinjohnedamana/32/17378_2.png) [@abinjohnedamana](https://forum.shopware.com/u/abinjohnedamana)\
**Post date:** [30. Dezember 2019 um 12:48 UTC](https://forum.shopware.com/t/how-to-write-join-condition-with-dal-search-in-shopware-6/63743/1 "2019-12-30T12:48:13Z")

</div>

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?