如何在一对多关系中有效地检索数据

I am running into an issue where I have a need to run a Query which should get some rows from a main table, and have an indicator if the key of the main table exists in a subtable (relation one to many).I am running into an issue where I have a need