Hi guys basically i have a got a search application on a mobile phone, where the value entred by the user is pattern matched agianst the records in teh database.

i wnat five tables from my database to be patern matched to the input value, how do i do this??

how do i create a JOIN for 5 tables?? please help..been tryin to do this all day and cant figure it out

my sql query to search 1 table is:

SELECT Functions FROM MsgTble WHERE Names LIKE '*sub*'

the Functiosn holds the correct name of function in mobile such as onbox outbox etc the Names are teh alternatives the user can enter such as read message,new message, this should then bring up the result Inbox etc

PLease help!!!