Php Mysql select query not working

Question

The below query results in the following error:

SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'AccountId' in where clause is ambiguous

$select = $this->select()
            ->from(array('finance_account' => DB_TABLE_PREFIX . 'finance_account'), array(
                    'AccountId',
                    'ParentAccountId',
                    'AccountGroupId',
                    'AccountPath',
                    'AccountCode',
                    'AccountName',
                    'Description'
                ))
            ->joinLeft(array('ac' => DB_TABLE_PREFIX . 'customer'), 'finance_account.AccountId = ac.AccountId', array())
                    // using "array_unique()" to minimize db overhead
             ->where('AccountId IN (?)', array_unique($parentIds))
            ->setIntegrityCheck(false);

I don't have any other column to do the join. What am I supposed to do now?

You need to specify the table for AccountId, like table.AccountId because your query doesn't know which table to look at. — Jay Blanchard
– Jay Blanchard, Commented May 11, 2015 at 17:36

Jamsheer Kandoth · Accepted Answer · 2015-05-14 07:20:55Z

1

AccountId put like finance_account.AccountId or ac.AccountId because query ambiguous on which table to look at

$select = $this->select() ->from(array('finance_account' => DB_TABLE_PREFIX . 'finance_account'), array( 'AccountId', 'ParentAccountId', 'AccountGroupId', 'AccountPath', 'AccountCode', 'AccountName', 'Description' )) ->joinLeft(array('ac' => DB_TABLE_PREFIX . 'customer'), 'finance_account.AccountId = ac.AccountId', array()) // using "array_unique()" to minimize db overhead ->where('ac.AccountId IN (?)', array_unique($parentIds)) ->setIntegrityCheck(false);

answered May 14, 2015 at 7:20

Jamsheer Kandoth

1921 gold badge3 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Php Mysql select query not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related