database: account leads membership

cgirabawe
Level 1

database: account leads membership

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?

1 REPLY 1
cgirabawe
Level 1

Re: database: account leads membership

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