Getting data from Multiple tables

Krishna Kumar

9y924

Hi,

I have Multiple tables in my database nearly 200. I want to get the data from all the tables based on an Order Number. Is it possible?. I need to get all the data related to that order number in all the tables and display in another table.

thanks

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bikesh Srivastava9y ago
Its big deal you should use join.
otherwise view.
0
Nigel Fernandes9y ago
Try something like this:
declare @sql as varchar(max)
set @sql = 'select * from table where ordernumber = 12345';

while(condition)
begin
    set @sql +=  'required tables';
end

exec(@sql)
0
Krishna Kumar9y ago
Hi Nigel,
Thanks for the reply. Can you please provide me the sample code so that i can understand and try the same.
0
Nigel Fernandes9y ago
Create the query using a for loop in a string and then use exec (string) dynamically.
0
Krishna Kumar9y ago
Hi Rajesh and Daniel
Thanks for your replies. Is there anyway other than joins to achieve my query.
I need to get the data from all the 200 tables and loop through the tables and display them in single table.

Thanks
0
Daniel Jones9y ago
you can use SQL join to get data from multiple tables:
http://databases.about.com/od/sqlserver/fl/Retrieving-Data-from-Multiple-Tables-with-SQL-Joins-Inner-Joins.htm
https://www.tutorialspoint.com/sql_certificate/get_data_from_multiple_tables.htm
0
Rajeesh Menoth9y ago
Hi,

You can retrieve data from multiple table using Sql Joins.

Reference :

https://www.tutorialspoint.com/sql_certificate/get_data_from_multiple_tables.htm

http://www.sql-ex.com/help/select5.php
0