i have a prblme in a displaying a report
Table username
username dep_code
----------------------------------
testuser Sal,Pur
testuser1 sal,Acc
testuser3 acc,pur
TAble department
dpet_id Name
---------------
Sal Sales Department
Pur Purchace Department
ACC Accounts Department
in the report search criteria i will give the department input as Sal , in the output i want
to display the userlist who belong to the department sal specfied in the saerch and also it has to display if he belong to other department also
output
testuser sal-sales department , pur-purchase department
testuser1 sal-sales department , Acc-Accountd Separtment
Will anyone provide me a query for the above problem
thanks in advance
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
