How can I get leads which are member to a given account? I am aware of tables mkt_account and mkt_person however the mkt_account is always empty and the field mkt_account_id in mkt_person is always NULL. Can someone give me a tip on how query leads with the accounts they belong to?
Finally found a database with populated tables. Here is the code:
select <some fields from tbl1> from mkt_person as tbl1
join mkt_account as tbl2 on tbl2.id = tbl1.mkt_account_id