{!join from=fromField to=toField fromIndex=fromCoreName}fromQuery

SELECT * FROM brands b
       INNER JOIN products p ON b.id=p.brand_id
       WHERE p.name="iPad";