Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Sql Tables

Author  Topic 

pavansql
Starting Member

1 Post

Posted - 2011-09-27 : 22:08:20

Hi Everybody.

I am new to sql.and i got a new job in crystal reports.so i need little help.

in the job they gave 10 columns to show up in the report.
But in the database they are like 500 tables.so how can i get those 10 columns from the tables.can some one plz help me with that.

Thank you,.
Pavan.



pavan m

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-09-27 : 22:13:04
do you know which column to show from which table ?


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-27 : 23:15:51
first you need to show the tables where you find those 10 columns
then show us the columns by which tables are related and specify type of relation (one to one, one to many etc)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -