[sqlite] Select statement help

[Andrew Drummond]

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)
{
    for each element2 in (select numbers.* from numbers where address_id =
element1.address_id LIMIT 20)
    return element1.* , elemen2.number
}


That is.... given....

table "address" contains

address_id  ,   name
------------------------------
1                ,    Peter
2                ,    Paul
3                ,    Mary
4                ,    Bob


and table "numbers" contains

address_id  , number
---------------------------------
1                , 12345678
2                , 12345678
1                , 09876654
4                , 87876765

the output would be

1                Peter            12345678
1                Peter            09876654
2                Paul             12345678


Thanks in advance

Andrew
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users