Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Parameterized view and multiple tables Prob.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00460933
Message ID:
00461315
Views:
16
hi Garrett,

You used these code

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

istead of these code

FROM mhngroup!groupname LEFT OUTER JOIN mhngroup!group;
LEFT OUTER JOIN mhngroup!groupnum;
LEFT OUTER JOIN mhngroup!notedata ;
ON Notedata.groupkeyid = Group.groupkey ;
ON Groupnum.numkey = Group.numkey ;
ON Groupname.namekey = Group.namekey;

Why do you want t change this?



Jim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform