>Hi,
> I have 3 tables. And I have summary it into the following format:
>
>

>Result (1st stage report)
>Topup          100
>Puchase        200
>FCard          300
>Userid(not dislayed)
>
>And I need to display my report as the following
>UserID : 00001
>UserName: User1
>
>Topup          100
>Puchase        200
>FCard          300
>
>UserID : 00002
>UserName: User2
>
>Topup          100
>Puchase        200
>FCard          300
>
>

>I need the userid and user name only existed in report if there are matched result 1st stage report.

What is your database engine? If Access use it to build your query.