Sql join query to display.

huma maheswari

8y787SQL

I attached database below and i need a query(i given query below what fields are required).

Thanks in advance.

3 Replies

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

Hiten Pandya8y ago
Okay... So, from your reply I made the database with all the tables that you described and then make an query which will give you the exact output that you want. If you have any query let me know.
select tu.User_Name,tu.Email,tu.Mobile,tu.Tech_Id,tt.Tech_Name,bd.BatchDetailsID,bd.BatchStartDate,bd.BatchEndDate,tu.Status_Id,ts.Status_Name from tb_BatchDetails bd
inner join tb_Tech tt
on tt.Tech_Id = bd.Tech_Id
inner join tb_User tu
on tu.Tech_Id = bd.Tech_Id
inner join tb_Status ts
on ts.Status_Id = tu.Status_Id
where Batch_Id = 1
Hope it helps you.
huma maheswari8y ago
sir,
I give batch id as input based on the batch i want
UserName,Email,Mobile,Status,Batch,Technology fields into the grid view i want the query
Hiten Pandya8y ago
Hiii huma, I saw your database but can you please be more specific about what kind of exactly output you want ? So, I can help you.