SELECT
Member.MemberID,
Member.Firm,
Member.FirstName,
Member.MiddleName,
Member.LastName,
Member.Address,
Member.Address1,
Member.City,
Member.State,
Member.PostalCode,
Member.Phone,
Member.URL,
Member.Fax,
Member.Email,
Member.NewsLetter,
Member.Advertising,
Member.HostMeeting,
Member.MembershipStarted,
Member.Ref1Name,
Member.Ref1Position,
Member.Ref1Email,
Member.Ref1Phone,
Member.Ref2Name,
Member.Ref2Position,
Member.Ref2Phone,
Member.Approved,
Member.Active
FROM
Member
WHERE
Active <> 0
AND Approved <> -1
ORDER BY
Member.Firm, Member.FirstName, Member.LastName
SELECT
Member.MemberID,
Member.Firm,
Member.FirstName,
Member.MiddleName,
Member.LastName,
Member.Address,
Member.Address1,
Member.City,
Member.State,
Member.PostalCode,
Member.Phone,
Member.URL,
Member.Fax,
Member.Email,
Member.NewsLetter,
Member.Advertising,
Member.HostMeeting,
Member.MembershipStarted,
Member.Ref1Name,
Member.Ref1Position,
Member.Ref1Email,
Member.Ref1Phone,
Member.Ref2Name,
Member.Ref2Position,
Member.Ref2Phone,
Member.Approved,
Member.Active
FROM
Member
WHERE
Active <> 0
AND Approved = 1
AND NewsLetter = 0
ORDER BY
Member.Firm, Member.FirstName, Member.LastName
| #qMember.Firm# |
| #qMember.FirstName# #qMember.MiddleName# #qMember.LastName# |
#qMember.Address#
#qMember.Address1#
#qMember.City#, #qMember.State# #qMember.PostalCode# |
| #qMember.Phone# |
| #qMember.Fax# |
|
|
  |  | |
|
|
|
|
|
