"Nick Zukin" <[EMAIL PROTECTED]> wrote on 03/14/2005 05:22:38 PM:
> I'm trying to do a multitable query and am having problems.
>
> I have three tables: vendors, products, and vendorproducts. The
> vendorproducts table creates a many to many relationship between the
vendors
> and the products. T
Thanks. That was it. I'm glad it was something so simple. Just needed a
careful set of eyes. I was worried my understanding of SQL/JOINs was
screwy.
Thanks again.
Nick
PS I'll read up on the FULLTEXT matching. I don't know it well.
>> $query = "SELECT v.vbusiness, v.vcategory, v.vurl, v.v
Nick Zukin wrote:
I'm trying to do a multitable query and am having problems.
I have three tables: vendors, products, and vendorproducts. The
vendorproducts table creates a many to many relationship between the vendors
and the products. There is nothing more than the vendor and product ids in
the
List
Asunto: Re: Multi-Table Query Problem...
On Mon, 14 Mar 2005 15:12:18 -0800, Scott Klarenbach wrote
> Because, with the '%keyword%' operator, you're going to match any of
> those columns that contain the keyword inside of it. This can be a
> little confusin
On Mon, 14 Mar 2005 15:12:18 -0800, Scott Klarenbach wrote
> Because, with the '%keyword%' operator, you're going to match any of
> those columns that contain the keyword inside of it. This can be a
> little confusing as 'ef' will return true on 'abcdefghijk'? Instead,
> you might try 'keyword%'
Because, with the '%keyword%' operator, you're going to match any of
those columns that contain the keyword inside of it. This can be a
little confusing as 'ef' will return true on 'abcdefghijk'? Instead,
you might try 'keyword%' so that 'apple' returns true for 'apples',
'apple juice', 'apple ci
What are the results?
sk
On Mon, 14 Mar 2005 14:22:38 -0800, Nick Zukin <[EMAIL PROTECTED]> wrote:
> I'm trying to do a multitable query and am having problems.
>
> I have three tables: vendors, products, and vendorproducts. The
> vendorproducts table creates a many to many relationship between
I'm trying to do a multitable query and am having problems.
I have three tables: vendors, products, and vendorproducts. The
vendorproducts table creates a many to many relationship between the vendors
and the products. There is nothing more than the vendor and product ids in
the vendorproducts tab
