[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
SQL Q.
Hi All
I have two tables in MySQL (products,rank).
The PRODUCTS is for all the product details and the RANK table is for
telling in which section the product can be.
So I do
[page scan
st=sql/fi=rank/sf=shop/se=1/so=AND/sf=category/se=1H/so=AND/fi=products/sf=Status/se=Active/sp=res-palace/ml=9]
<IMG SRC="pic.jpg">[/page]
which supose to be.
select products.code,shop,status FROM products,rank WHERE (products.code
= rank.code) and (category = "1H") and (shop = "2") and
(Status="Active");
its give the next error
Runtime error: Column: 'code' in field list is ambiguous at
/usr/local/mvend/lib/Vend/Table/DBI.pm line 379.
--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-6-6925757
Fax: 972-6-6925858
http://www.canaan.co.il
--------------------------
