[fw-general] select ... from ... where ... in

[Dan Field]

Anybody know how I might use the 'in' syntax from MySQL to produce the  
following nested query using Zend_Db ?

    select
        d_articleid, d_divid, d_pageid
    from
        wjo_div
    where
        d_articleid in (
            select
                a_articleID
            from
                wjo_article
            where
                a_articlecode like '%001' and
                a_publicationID = 037
        )
    order by
        d_pageid;

--
Dan Field <[EMAIL PROTECTED]>                   Ffôn/Tel. +44 1970 632 582
Peiriannydd Meddalwedd                                 Software Engineer
Llyfrgell Genedlaethol Cymru                   National Library of Wales