<CFQUERY NAME="readesi" DATASOURCE="esidb1">
SELECT DISTINCT tblmasterclients.ClientName, AliasName, AlphaPrefix, SiteID, Infinity, AuthCode, POBox, POBoxCombo, tblmasterclients.Comments, DID,
SVCType, tblmasterclients.AcctStatus, PreparedDate, URL, TerminationReason, TerminationDesc, billingaddr, billingaddr2, billingstate, billingcity,
billingzip, billingcontact, billingemail, billingphone, billingext, billingfaxnumber, billingcellnumber, legalname
FROM tblMasterClients, tblbillingaddr, tbllegaladdr
where tblmasterclients.clientname = tbllegaladdr.legalname
and tblmasterclients.acctstatus = 'A'
OR tblmasterclients.acctstatus = 'ACT'
ORDER BY tblmasterclients.clientname
The query seems simple enough but what's not obvious is the relationships between some of the tables. If I posted a screen cap of the relationship, any chance I could get some help?
Thanks!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
