Use the following query for your dataflow source:

select b.GROUP_ID, b.NAME, b.STATE

from TableB b

join TableA a on b.GROUP_ID = a.GROUP_ID

where a.STATUS = 'Ready'