Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ugly SQL
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00563216
Message ID:
00563223
Views:
18
Unnest the joins. You will have to maintain this view programmatically and no longer use the view designer. Use EView from UT Downloads.
SELECT CONFIGFILES.*, ;
      PARAMETERS.CNAME, ;
      PARAMETERS_A.CNAME, ;
      PARAMETERS_B.CNAME, ;
      PARAMETERS_C.CNAME ;
   FROM GULFSTREAM!CONFIGFILES ;
      LEFT JOIN GULFSTREAM!PARAMETERS ;
            ON CONFIGFILES.IREMOTEPARAM1 = PARAMETERS.IPARAMID ;
      LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_A ;
            ON CONFIGFILES.IREMOTEPARAM2 = PARAMETERS_A.IPARAMID ;
      LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_B ;
            ON CONFIGFILES.IREMOTEPARAM3 = PARAMETERS_B.IPARAMID ;
      LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_C ;
            ON CONFIGFILES.IREMOTEPARAM4 = PARAMETERS_C.IPARAMID ;
   WHERE CARTICLEID = ?VP_CARTICLEID
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform