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 , 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 > -- Seun Osewa http://www.nairaland.com/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users