Join Queries

[rleinen]

Is there a way to do the following in datamgr?

select
t.*
from
tasks t inner join taskusers tu on t.usernum = tu.usernum
where
t.taskdate = somedate
AND tu.usernum = someusernum

Or, is it possible to do the following:
1. Create a virtual column on the task table
2. Use that column as part of the filter criteria

Thanks for any assistance,
Randy

[Steve Bryant]

Other than resorting to the AdvSql argument, DataMgr doesn't provide
any way to do a join.

It does, however, provide the ability to do a virtual column. This is
called a "Relation Field" in DataMgr and you can filter by it just as
you would any real database field.
http://www.bryantwebconsulting.com/docs/datamgr/relation-fields.cfm

Thanks,

Steve