anyone know how to select the Accounts from bcm's database with sql?

[James]

anyone know how to select the accounts from bcm's database with sql? i can't
seem to pull just the accounts. i would also like relate the contacts too.
it seems like ContactServiceID is the primary key for the accounts. but i
still can't get a accurate list of all accounts. has anyone else played with
the back end more than me and know the design better?

 

[Luther]

To get all the Accounts try something along the lines of
"SELECT * FROM AccountsFullView"

To filter out the deleted Accounts add
"WHERE IsDeletedLocally = 0"

You can do a JOIN of Accounts with ContactsFullView using the ParentID.

I may not have the names 100% right, but you get the idea.