Hey all, I'm a newbie so I appreciate any help you can offer.

I'm pulling employee information data from multiple tables and one of my fields (Supervisor) is returning as "***"

I'm not sure if there is something I need to set, and I'm probably overlooking something obvious. The line that pulls the data from the other table is:

AA$SIS$Get_superviser_name(std.superviser_number,s td.location,1)||','||

(I have the SELECT portion formatted to output in a csv format)

I'd appreciate any suggestions

Thanks

Dee

Well, I've found out what the problem was.

1) *** indicates an empty field
2) Admin had 2 SQL accounts set up for me. These 2 accounts conflicted and restricted access to some tables. Once one of the accounts was deleted, the query ran correctly witht he expected outcome.

Cheers
Dee