Is it possible to shorten the request here?

Question

C++ / C#

Good afternoon everyone. Is it possible to somehow reduce these requests, that is, to unite them?

join t_drugs in db.Drugs on t_orders.DrugsID equals t_drugs.Id //id данные препарата
                            join t_ndrug in db.DrugsDicts on t_drugs.DrugsDictID equals t_ndrug.Id //название препарата
                            join t_dosdrug in db.DosageDicts on t_drugs.DosageDictID equals t_dosdrug.Id //название дозировки

Answer 1

This issue has been resolved and it makes sense to reduce the request, which is already optimally reduced.