Hi
What you need to is to join two tables ,when you select both the tables in Database Expert and click next a new tab will be created called Links Click on that tab you will see the tables no what you need is to link the tables
Select Cr# from Table One and drag towards Table 2 and link to CR# from table 2 this will be a inner join .
Then you can select fields that you want from Table1 and Table 2
Note:-The report will only return matching records from both the tables which have common CR# id as it is inner join
Cheers
Rahul
Edited by rahulwalawalkar - 19 Dec 2008 at 1:43am
IP Logged
