Reporting over Account field in Accounts

[REByers]

I have created a one to many relationship field in the accounts module.

It's purpose is to link an account to it's sales channel.

I now want to report over this field, so that I can pull up a list of customer accounts for a channel.

I just get a SQL error in the erports module though.

Here's the error, and all help greatly appreciated!!! The query just looks for records with none baln kentries inthe field.

Error executing query Query Failed:SELECT accounts.id primaryid ,accounts.name accounts_name ,accounts_cstm.account_id_c accounts_cstm_account_id_c ,accounts.name accounts_name,accounts.description accounts_description FROM accounts LEFT JOIN accounts_cstm accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN accounts accounts ON accounts.id = accounts_cstm.account_id_c WHERE ((( accounts_cstm.account_id_c IS NOT NULL AND accounts_cstm.account_id_c<>'' ) )) AND accounts.deleted=0 LIMIT 0,100::MySQL error 1066: Not unique table/alias: 'accounts'

[kbrill]

I cannot reproduce this locally, can you either give us more details (report details and/or screen shots) or submit a case on this and we will figure it out for you.