Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL optimization
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00246060
Message ID:
00246142
Views:
18
Fix that

>
>
>
>	?SYS(3054,2)
>	SELECT DataPPO.* ;
>			, ReimbrsKey AS OldReimbrs ;
>			, OtherId AS OldOtherId ;
>			, DtToCompJul( MaintDate) AS MaintComp ;
>			, DtToJul( MaintDate) AS MaintJul ;
>			, dmlError.dm_Link ;
>			, "K" AS StatusCode ;
>			, DataPPO.Tax_Sufx AS Old_Sufx ;
>			, .F. AS REPLACED ;
>			, dmlError.CODE ;
>		FROM DataPPO ;
>		LEFT JOIN dmlError ;
>			ON DataPPO.Fed_TaxId <strong>+</strong> DataPPO.Tax_sufx = ;
>                           dmlError.Fed_TaxId + dmlError.Tax_sufx ;
>		INTO TABLE dmoPPO
>
>
>
>Make sure there is an index on each table for Fed_taxid + tax_sufx for Rushmore.
Previous
Reply
Map
View

Click here to load this message in the networking platform