"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,
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
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
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,address where
numbers.number = "12345678" and numbers.address_id = address.address_id)
{
4 matches
Mail list logo
