Please help create crystal report using query

See more:

VB

I want to get the report from two tables using query
In my table has following

TAble1
Billno  Code     Description   Amount  Totamt Tax Nettot 
1        W001    Webhost       3000     5000   50  5050
1        W002    Domain        2000     5000   50  5050

Table 2
ID Billno      Nettot    Paid   Pending
01    1         5000      3000   2000
02    1         5000      1000   1000

so i want the report like

Billno:1      
Code        Description     Amount
W001        Webhost         3000
W002        Domain          2000

                        Total     5000
                        Tax         50
                        NetTotal  5050
                        Paid      4000
                        Balance   1050  

Please help me how to give the query string for get report

Thank you