Re: Sub-Select query

2002-12-12 Thread David Bordas
> I have the following query. When executed in MySQL I get an error on the > first sub-select, and I can't find why: http://www.mysql.com/doc/en/News-4.1.x.html You'll see that sub-select query will be in future 4.1.xx rel

Sub-Select query

2002-12-12 Thread Christos Vorkas
Dear all, I have the following query. When executed in MySQL I get an error on the first sub-select, and I can't find why: select slbc.stockcode, s.description, slp.qtyinstock, smax.pluqty, (slp.qtyinstock / smax.pluqty) from stocklevelbc slbc, stock s, stocklevel slp, stock smax, stockle