Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized view and multiple tables Prob.
Message
 
To
08/01/2001 20:20:25
Spencer Redfield
Managed Healthcare Northwest, Inc.
Portland, Oregon, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00460933
Message ID:
00460934
Views:
10
>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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform