Create report with two related tables and select column from different table

Hi All,

I want to create simple list report out of two table person and ADSAcount.

In where clause I can put join on tables but also want to select columns from both tables in report.

Below is my definition file.

<DatabaseExportDefinition BaseTable="PERSON" BaseTable="ADSACCOUNT">
  <WhereClause>UID_PERSON IN (SELECT P.UID_PERSON FROM PERSON P INNER JOIN ADSACCOUNT ADS ON P.UID_PERSON = ADS.UID_PERSON WHERE ((P.IMPORTsource = 'SAPHR' OR P.IMPORTSOURCE = 'DERDE')))</WhereClause>
  <Columns>
    <Column ExportDisplay="True" ColumnName="PersonnelNumber" TableName="PERSON"/>
    <Column ExportDisplay="True" ColumnName="importsource" TableName="PERSON"/>
    <Column ExportDisplay="True" ColumnName="FIRSTNAME" TableName="PERSON"/>
    <Column ExportDisplay="True" ColumnName="LASTNAME" TableName="PERSON"/>
    <Column ExportDisplay="True" ColumnName="DefaultEmailAddress" TableName="PERSON"/>
    <Column ExportDisplay="True" ColumnName="UID_Department" TableName="PERSON"/>
    <Column ExportDisplay="True" ColumnName="customproperty05" TableName="PERSON"/>
    <Column ExportDisplay="True" ColumnName="CustomProperty06" TableName="PERSON"/>
    <Column ExportDisplay="True" ColumnName="EntryDate" TableName="PERSON"/>
	<Column ExportDisplay="True" ColumnName="CN" TableName="ADSACCOUNT"/>
	
  </Columns>
</DatabaseExportDefinition>

When I preview report, I get error.

Is it possible to do this if yes then can you help me to get this done.

Kind Regards,

Dnyandev