Sql join query to display.

Question

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

huma maheswari · Answer

sir I give batch id as input based on the batch i want UserNameEmailMobileStatusBatchTechnology fields into the grid view i want the query

Hiten Pandya · Answer

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.

Hiten Pandya · Answer

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_Nametu.Emailtu.Mobiletu.Tech_Idtt.Tech_Namebd.BatchDetailsIDbd.BatchStartDatebd.BatchEndDatetu.Status_Idts.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.