I have the following problem, I will receive a bank with "x" available positions in several specialties and another with "y" patients requesting those specialties follows the model of the tables below, would have to elaborate a query that would make available the vacancies for the patients that they contacted first and requested the specialties of the table vacancies:
CurrentlymyqueryisassigningallthevacanciestothesamepersonandsoitkeepsrepeatingItriedtouseCTEandselectcommonbutIhavenoideahowtoapplythiscondition.
They could help me because I have no idea how to cross the two tables giving their respective vacancies to their respective clients.