Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Parameterized view and multiple tables Prob.
Message
 
À
08/01/2001 20:20:25
Spencer Redfield
Managed Healthcare Northwest, Inc.
Portland, Oregon, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00460933
Message ID:
00460934
Vues:
8
>For the first time I need to create a parameterized view utilizing > 2 tables
>and am not succeeding. (I'm using the view designer but have also tried to
>create the view from the command line without success.)

Try it like this:
CREATE VIEW myView AS ;
   SELECT Group.groupkey, Group.suffix, Groupname.groupname,;
          Groupnum.groupnum, Notedata.textnote;
      FROM mhngroup!groupname ;
         LEFT OUTER JOIN mhngroup!group ON Groupname.namekey = Group.namekey ;
         LEFT OUTER JOIN mhngroup!groupnum ON Groupnum.numkey = Group.numkey ;
         LEFT OUTER JOIN mhngroup!notedata ON Notedata.groupkeyid = Group.groupkey ;
      WHERE Group.groupkey == ?thisform.CurrentGroupKey;
        AND Group.suffix == ?thisform.CurrentGroupSuffix
My blog
My consulting page
My home page

Member of the Trim Your Auto-Quote Campaign!
What's another word for thesaurus?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform