sql lite question

[David Faerman]

Hello,

Sorry for the offtopic... is an sqllite question...

i have 3 tables, persons, persons_titles, titles

persons has 2 fields id(int), name(varchar(30))

titles has 2 fields title_id (int), title_name(varchar(30))

persons_titles has 3 fields id(int) persons_id(int) title_id(int)

persons may have multiple titles how i get something like

persons,id persons.name title1 titl2 title3 ?

i know i need to use some joints but what is the best way?

Thanks!!!
and again sorry for the offtopic

--
 (\__/)
(='.'=)This is Bunny. Copy and paste bunny into your
(")_(")signature to help him gain world domination.