Just to clarify the OP, the Where Match statement will go in the preceding load statement rather than the SQL Select statement
LIB CONNECT TO [pharmoresql production (pharmore_rwinkel)];
WHERE Match(FGName, 'Bria Management','Carr','DAAS Management');
SQL SELECT FGID,
But this would require to bring in unnecessary data through SQL which you will remove in the preceding load. So, I think it would be better to restrict in your SQL statement using OR method that Stefan has pointed out or use another similar approach.