Re: FULLTEXT across two tables

2004-01-06 Thread Michael Stassen
27; is specified... any other thoughts? Thanks, lje On Saturday 03 January 2004 16:58, you wrote: Hi Ladd, How about SELECT DISTINCT? Hope that helps. Matt - Original Message - From: "Ladd J. Epp" Sent: Saturday, January 03, 2004 11:39 AM Subject: FULLTEXT across two tables Hell

Re: FULLTEXT across two tables

2004-01-05 Thread Ladd J. Epp
ISTINCT? > > > Hope that helps. > > > Matt > > > - Original Message - > From: "Ladd J. Epp" > Sent: Saturday, January 03, 2004 11:39 AM > Subject: FULLTEXT across two tables > > > Hello, > > > > I would like to do a FULL

Re: FULLTEXT across two tables

2004-01-03 Thread Matt W
Hi Ladd, How about SELECT DISTINCT? Hope that helps. Matt - Original Message - From: "Ladd J. Epp" Sent: Saturday, January 03, 2004 11:39 AM Subject: FULLTEXT across two tables > Hello, > > I would like to do a FULLTEXT search across two tables. I run an art

FULLTEXT across two tables

2004-01-03 Thread Ladd J. Epp
Hello, I would like to do a FULLTEXT search across two tables. I run an artist website, so I need to search across the user list and the users' associated art pieces list. I've come up with this query (fulltext indexes for these precise values have been created on both tables): SELECT * from