database: account leads membership

[cgirabawe]

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?

[cgirabawe]

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