Hugh Middity
New Member
Suppose that you have a table of support calls that contains an AssignedTo column (linking to another table of users). If you also have a history table that stores details of who worked on a support call and when, how could you query a Progress 9.1D database to get a listing of all the support calls that are assigned to a Fred or have been worked on by Fred?
In sql, the pseudo query would be something like:
select * from SupportCall where AssignedTo = 'fred'
or SupportCall.Id in (select SupportCallHistory.SupportCallID from SupportCallHistory where SupportCallHistory.User = 'fred')
Is there a way to get the equivalent using 4GL?
Thanks for any suggestions.
In sql, the pseudo query would be something like:
select * from SupportCall where AssignedTo = 'fred'
or SupportCall.Id in (select SupportCallHistory.SupportCallID from SupportCallHistory where SupportCallHistory.User = 'fred')
Is there a way to get the equivalent using 4GL?
Thanks for any suggestions.