Select Columns from more then 1 table

ReportServer (EN)
1

SELECT adc.*,c.CustomerName FROM dbo.XYZ adc INNER JOIN PQR c ON c.CustomerNumber = adc.CustomerNumber

when i execute this query it displays all columns from XYZ table and CustomerName from PQR table
But when i execute report to select column, it display’s all columns from PQR table but none column from XYZ table
So Kindly help me to Fetch columns from PQR as well as XYZ table

2

Hi kirti,

normally this should work without problems.
Do you see the problem already in the preview of your dataset?
Do you have set filters in your dataset?
Are the data types of the column “Customernumber” in both tables the same?

If you generate the report as HTML Output, are there error messages at the end of the report?

Regards

thbritz

3

Hi thbritz,

There was no problem in previewing the data.
And now it is working fine i made mistake in query.
Thanks for your help :slight_smile:

4

Hi kirti,

I guess the correct query for seeing all columns would be:

SELECT adc., c. FROM dbo.XYZ adc INNER JOIN PQR c ON c.CustomerNumber = adc.CustomerNumber

correct?

Greets,
Eduardo

5

Hi Eduardo,

You’re correct Eduardo Thanks :slight_smile: