Magento 1.9 join query

I am trying to build a custom grid with a custom query with joins.
I will try to explain my problem as simple and thorough as I can.

The one thing i can't figure is why my left join does not work. It only gives me a blank page with the title of my custom grid.
This is the line where i try to make the join:

// sales_flat_order_payment
->joinLeft(array('sfop' => 'sales/order_payment'), 'sfoa.parent_id = sfop.parent_id WHERE main_table.base_price > '0.000'', array(
'PaymentMethod' => 'method'))


When i make the line like: (without left in it)

->join(array(...


It does work but it automatically makes it a INNER JOIN.
I also have tried these but none of them works:
→joinInner() →joinLeft() →joinRight() →joinFull() →joinCross() →joinNatural()

The functions are defined in this file: lib/Zend/Db/Select.php

I would very much appreciate if someone could help me or advice what to do.

Greetings,
Roy

1 Answer
1

After searching and trying different methods i found one that works.
Here is what i used to make a join left:

$collection->getSelect()->joinLeft(
array('sfop' => 'sales/order_payment'), 'sfoa.parent_id = sfop.parent_id WHERE main_table.base_price > '0.000'', array(
'PaymentMethod' => 'method'))


Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Some of your past answers have not been well-received, and you're in danger of being blocked from answering.

Please pay close attention to the following guidance:

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

Required, but never shown

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.