> Hi All
>
> 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]
