Hi

Is it possible to emulate this in Zend_DB_Table:

SELECT A.team, B.fname, B.sname
FROM `teams` A, `players` B
WHERE MATCH (B.fname,B.sname) AGAINST ('Derby')
AND A.team_id = B.team_id;

So I have a join here and also some MySQL keywords, I have relations set up in my objects

Cheers

Ian

Reply via email to