 |
 |
Archives of the TeradataForum
Message Posted: Tue, 03 Aug 2004 @ 10:14:57 GMT
| Subj: | | Re: QueryID and Joining DBQLogTbl to DBQLObjTbl |
| |
| From: | | Howard Bradley |
We have had loads of "fun" recently with these tables and ended up implementing a solution along the lines already suggested. Since then a chap
from NCR suggested that a good approach is to include the timestamp in the Account string of the logons as the expanded account string exists on
both tables. This then gives a good join (logically). I haven't have chance to test any of this yet (and won't for some time) so don't know if it
will work. Perhaps one of you can do that for me :-)
Howard
| |
