About
This report shows active entries in the Address Book with specialty name.
A sample image of this SQL report run in the Database Viewer is shown below:
Caveats
None.
Code
To highlight and copy the code below to your clipboard, simply click the Copy button.
select specialty_name, fname, lname, company, address, city, state, zip, bphone1, note, direct_email from ( select addressbook.*, specialty_name from addressbook inner join doc_specialty on doc_specialty.doc_addr_id = addressbook.addr_id inner join specialty on specialty.specialty_id = doc_specialty.specialty_id where addressbook.is_active=1 ) a