Select Name,Reporting
From tblConfig_Queue
Where Pkey in (Select FKQueue From tblConfig_QueueGroupMembers Where FKQueueGroup ='FKQueueGroupOfYourChoice')