Thursday, June 26, 2008

GoldMine: How can I find contacts with no email address since I cannot filter from this field?

You can find contacts with no e-mail address by running the following SQL query:

* Or you can use the following SQL query:
SELECT accountno, company from CONTACT1 where accountno not in (SELECT accountno from CONTSUPP where rectype = 'P' and contact = 'E-mail Address')

* After running the SQL query you can create a Group based on the query

* Go to Lookup > Filters

* Go to the SQL Query tab and run the Query

* Go to the Groups Tab and on the top half of the screen right click and choose New

* Name the Group and choose Next

* The Group Building Wizard will pop-up

* Choose SQL Query Records

* Select the field you would like the Group sorted by

* You can add a Reference Field and Filter Expression if you wish (for this purpose we will not)

* Choose Next and Finish and the Group will be built based on the SQL Query

2 comments:

Anonymous said...

A further prevalent apply that is certainly meticulously based on exercise is definitely this with hips diminishment. If worn out for your extensive replica prada handbags of one's it has been tested not wearing running shoes does indeed in truth slow up the middle depending on style worn out this is definitely by pressuring a huge to the more affordable torso plus into the body abandoning a hips set compressed including a minimal lesser. prada replica has been a reflectivity with one’s design sensation plus approach, exactly how attire will be. Fads around natural beauty currently have applied the radical variations while in the the past svereal years. hermes replica machines became ground breaking and are generally displaying its inventiveness around fads this represent a switching moments. Pill breitling replica is preferred concerning gals lately. Its do not viewed as something which is definitely worn out exclusively by way of mature gals. Pearls absolutely are a sign with wholesomeness plus give a loan a vintage plus stylish please any one dressed in replica gucci handbags. A subtle shape with pearls as well shows the person wearing them some femininity. A person have wed one time this will probably be your working day that they are artistic and then to express your style plus very own flavour.

林磊 said...

2016-2-20 leilei
jordan retro 8
christian louboutin uk
air jordan 4
burberry outlet
ralph lauren outlet
air max
louis vuitton
tiffany and co
ugg outlet
oakley sunglasses
jordan retro 4
coach outlet online
ray ban sunglasses
oakley sunglasses
nike store uk
coach factory outlet online
michael kors handbags
coach factory outlet online
nike huarache
toms outlet
canada goose jackets
ugg boots
louis vuitton borse
burberry outlet
air jordan 8
chaussure louboutin
canada goose jackets
nike outlet
nike trainers
longchamp le pliage
louboutin outlet
montblanc pens
toms shoes
christian louboutin
ray bans
burberry scarf
michael kors bags
nike sb dunks
cheap jordans
pandora charms