Loading

Get data from multiple ids in one table

asif tariq

I have user,company and case table. when user login user see his own company which is assign in company table

if user have two companies then user saw her summary for both companies in one graph or grid from case table.

can i show data from two ids in one table or graph?how? please guide me.Thankyou

2 Replies

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

Amit Gupta6y ago
For fetching data from multiple tables, do take advantage of Sql query builder to avoid writing much syntax. Goto ssms->query menu-> build query (CTRL + SHIFT +Q)
Jignesh Kumar6y ago
Hi Asif,
You can use inner join to get data from both tabels.
join for user and company tabel using userId,
join for case table which has common coulmn from any of table

https://www.sqlservertutorial.net/sql-server-basics/sql-server-inner-join/