Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Additional Contacts where the DEAR field isn't completed

Useful SQL Queries

Additional Contacts where the DEAR field isn't completed

by  richardy  Posted    (Edited  )
select contsupp.contact,contsupp.dear from contsupp,contact1 where contact1.accountno=contsupp.accountno and rectype="C" and key1 like "Customer%" and (contsupp.dear is null or contsupp.dear = "")
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top