• So ... a single row in the Jobs table can have multiple related rows in the Drops table, is that correct?

    If so, you could make use of the FOR XML Path technique, which can create single comma-separated lists from multiple rows. Have a read here for an explanation.

    If you want a working example, you'll need to provide DDL, INSERT statements and desired results, as described in the link in my signature.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.