SQL Server Performance Forum – Threads Archive
retrieving data from different tables.
hi, i have three tables. one contains case history. second one is payment history. a third table contains search headers which contains certain column headers of the previous two tables. NOW my problem is retrieval of data from the first two tables based on the search headers in the third table (using SQL server). is it posiible and can anyone help in that.What kind of relationship u have defined for these three tables.
Its almost possible to retrive data based on the relationship.
True and it helps if you can post the sample structure of those 3 tables as well. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote:Originally posted by anusha_srs
hi, i have three tables. one contains case history. second one is payment history. a third table contains search headers which contains certain column headers of the previous two tables. NOW my problem is retrieval of data from the first two tables based on the search headers in the third table (using SQL server). is it posiible and can anyone help in that.
<br>
search table has the details of the column headers which should be displayed.
payment table has the payment details where id is the foreign key
user details has his personal details and id is the primary key
<br>
search table has the details of the column headers which should be displayed.
payment table has the payment details where id is the foreign key
user details has his personal details and id is the primary key
]]>