I am trying to create sql statement something like

SELECT T.title_id, T.title, S.qty FROM titles T LEFT JOIN sales S on T.title_id = S.title_id AND S.stor_id = '7131' ORDER BY T.title

(found this on the web. much more brief then my actual sql).

The problem I am having is how to get the join (relationship) to have the AND portion. I am assuming it would be an expression, but for the life of me I can't come up with acceptable syntax.

I am one of those learn by exmaple people so if you have code snipit that does this I would love to see.

In advance, thanks for you time.

Tim

Yes, please check: "Using the generated code -> selfservicing/adapter -> Filtering and sorting -> Custom filters for EntityRelations"

Otis, Thanks much. Though I went through the docs cover to cover. I guess not works perfectly!

Thanks for quick and patient response.

Tim

Tlaughlin wrote:

Otis, Thanks much. Though I went through the docs cover to cover. I guess not works perfectly!

Thanks for quick and patient response.

Tim

Well, it's 289 pages of info, so no-one can remember every detail in there, I even have to look things up now and then