ReportServer Forum

kirti

Member

Registered: 2017-01-13

Select Columns from more then 1 table

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

thbritz

Member

Registered: 2017-01-17

Re: Select Columns from more then 1 table

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

kirti

Member

Registered: 2017-01-13

Re: Select Columns from more then 1 table

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

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Select Columns from more then 1 table

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

kirti

Member

Registered: 2017-01-13

Re: Select Columns from more then 1 table

Hi Eduardo,

You're correct Eduardo Thanks