I have a order master table in which orderId is PK.
Now i have 5 Diffrent tables in which OrderId is FK. Column Name in each table is same.
I want to find all columns by orderId from all 5 tables. that means If i pass the orderid = 5 then query should check for each table and find the orderId = 5 and get all records from that table.
If you think any logic for solve this problem please write. I really thankfull if i got any clue for this.
Thanks & regards
View Complete Post