SQL Query in Formula 1

[cwsstins]

Using CR 8.5 on Oracle 8.1 db. My table looks like this:

LoginID FullName Mgr
JONESB Bob Jones ROTHT
SMITHJ Joe Smith ROTHT
ROTHT Tim Roth KENTJ
KENTJ Jim Kent KENTJ

In my report, I'm grouping by FullName and trying to show each person's manager. But instead of showing the Mgr column, which is a loginID, I want to show the manager's FullName. Each manager is also a LoginID/FullName.

So in SQL, I would want something like this:

SELECT FullName FROM Tbl WHERE Mgr = LoginID

...or something along those lines. How can I create a formula that will basically do the same thing?

 

[lbass]

I would just add the table a second time and call it table_mgr. Then link it to the first table by linking {table.mgr} to {table_mgr.loginID}. Then you can just place {table_mgr.fullname} on your report for the manager's name.

-LB

 

[cwsstins]

worked like a charm...thanks.