I think this will work
SELECT products.sku, products.title, products.price,
qty_price.qty, qty_price.qprice
FROM products, qty_price WHERE products.vendor_id=15 AND
prod_test.category='widgets';
Ruan
-Original Message-
From: boll [mailto:[EMAIL PROTECTED]
Sent: Thursday, D
LOL - Now I feel silly.
Thanks that worked.
R
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Friday, December 15, 2006 5:37 PM
To: mysql@lists.mysql.com
Cc: mysql@lists.mysql.com
Subject: RE: Strange table problem
At 03:44 AM 12/15/2006, Ruan wrote:
>Hi,
>
>
PROTECTED]
Sent: Friday, December 15, 2006 10:43 AM
To: Ruan
Cc: mysql@lists.mysql.com
Subject: Re: Strange table problem
I dont think product_beta.test is a table...It seems to be a view..
what is the create statement for it..
show create table product_beta.test; ???
-Lakshmi
Ruan wrote:
>Hi everyb
ideas on how to get rid of it?
Regards
Ruan Fourie
