select distinct client.cid, client.name, buys.iname, cname from client, buys, cafe
where buys.iname = 'cappuccino' and cafe.cname = 'abc';