DTS Query

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 1

Can you post your query here?? Are you discounting NULL values from the count?

Are you doing any GROUP BY or DISTINCT when pulling the data across?

Thanks,

AJ

Good Hunting!

SA-1 SSCrazy Eights Points: 8113 More actions · Answer 2

Here is the query...

SELECT a.no as no, a.date as date, a.key as key, a.memo as memo, b.name as name

FROM Cases_Table a INNER JOIN Dates_Table b on a.key = b.key

WHERE b.Name LIKE '%TICKLER%' AND len(a.memo) > 0 ORDER BY name, date, no

philcart SSC-Forever Points: 47794 More actions · Answer 3

Is this the same query syntax used when querying the Foxpro database?

Are you able to determine which records are excluded find out what is different about them.

--------------------
Colt 45 - the original point and click interface