I manage a MySQL database of ten or so tables.
In higher code, I have a list of primary keys belonging to entries of some table
A entries have foreign keys to entries in another table
B. The relationship is 1-to-many, so several
As may point to the same
Problem: I need to determine if the list of primary keys I hold in higher code (Scala) is homogeneous. That is, if their foreign keys to
B all correspond to the same entry in
Question: Would it be possible to determine this by analysing the results of a single SQL call?