SELECT * FROM `resource_allocation` INNER JOIN users ON resource_allocation.Client_id=users.client_id WHERE resource_allocation.Client_id=''