Alex Filatov

If you’re using such relations between your tables in database you’ll find useful the following article:

Many-to-Many Relationships with Propel

Some of you already know that if you want to get something from database via Symfony you should build a query with help of Criteria() object.

Here is the link to the Symfony book and you can get familiar with this there.
Symfony Criteria()

BUT there are only simple queries samples.

What if you need something like this:

SELECT
Table1.field1, Table1.field2, Table2.field1
FROM
Table1, Table2
WHERE
((Table1.field3=1 OR Table1.field4=1) AND
Table1.field5 < 400000) AND
Table2.field1=Table1.field1

or smth. like that.

I’ve found useful tool that help you to build such queries

Symfony Criteria code builder tool