subject:"substring and a join\?"

Re: substring and a join?

2001-03-05 Thread Bob Hall

>Hello, > >I have the following query: >"SELECT thara_plane.id,thara_plane.nam >e,thara_plane.nick,thara_plane.bodytext,thara_category.category " >."FROM thara_plane,thara_category,substring(thara_plane.bodytext,225) as >bodytext " >."WHERE ((thara_plane.category = thara_category.id)) " >

substring and a join?

2001-03-05 Thread Lauri Vain

Hello, I have the following query: "SELECT thara_plane.id,thara_plane.nam e,thara_plane.nick,thara_plane.bodytext,thara_category.category " ."FROM thara_plane,thara_category,substring(thara_plane.bodytext,225) as bodytext " ."WHERE ((thara_plane.category = thara_category.id)) " ."ORDER B