🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: adobe.golive.dynamic.content
Article #102

Re: Is it possible to do a full text match with joined tables.

#102
From: Jerry_Artman
Date: Thu, 29 Jul 2004 11:26
8 lines
954 bytes
Jeremy

In reading the mysql manual, it doesn't appear to allow joins.

It looks like a multi-step process to me.

find the faculty ids using match.
then lookup the classes using where faculty_id in list of the first match set.
Technical Details
Message-ID: <3bb53f82.0@webx.la2eafNXanI>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!zen.net.uk!dedekind.zen.co.uk!npeer.de.kpn-eurorings.net!feed.news.schlund.de!schlund.de!newsfeed01.sul.t-online.de!t-online.de!webx
References: <3bb53f82.-1@webx.la2eafNXanI>

Show Full Headers
Complete Article Headers
X-Google-Thread: 11ffd2,5be81bf8a12d8df7
X-Google-Attributes: gid11ffd2,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: Jerry_Artman@adobeforums.com
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!zen.net.uk!dedekind.zen.co.uk!npeer.de.kpn-eurorings.net!feed.news.schlund.de!schlund.de!newsfeed01.sul.t-online.de!t-online.de!webx
Newsgroups: adobe.golive.dynamic.content
Subject: Re: Is it possible to do a full text match with joined tables.
Message-ID: <3bb53f82.0@webx.la2eafNXanI>
Date: Thu, 29 Jul 2004 04:26:56 -0700
References: <3bb53f82.-1@webx.la2eafNXanI>
Lines: 9
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit