Re: [sqlite] Select statement help

"Andrew Drummond" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am trying to write an sqlite select statement that performs the > below pseudo code, but am getting nowhere. Any help we be very > appreciated. > > PSEUDO CODE > > for each element1 in (select address.* from numbers,

Re: [sqlite] Select statement help

Andrew Drummond wrote: > > for each element1 in (select address.* from numbers,address where > numbers.number = "12345678" and numbers.address_id = address.address_id) > { > for each element2 in (select numbers.* from numbers where address_id = > element1.address_id LIMIT 20) > return ele

Re: [sqlite] Select statement help

select a.address_id, a.name, n.number from address a, numbers n where a.address_id=b.address_id On Mon, Sep 22, 2008 at 8:28 PM, Andrew Drummond <[EMAIL PROTECTED]> wrote: > That is given > > table "address" contains > > address_id , name > -- > 1