SQL - me bad or parser bad

[Ruslan Zasukhin]

on 3/25/03 5:39 PM, Robert Brenstein at rjb at rz.uni-potsdam.de wrote:

> Problem:
> 
> Valentina selects records that should be excluded. Namely, records
> with non-empty u_canc field are included.
> 
> SQL query:
> 
> Select r_rid,r_lna,r_fna,r_mna,r_ema,r_tit,a_titl,
> a_cdts,r_fee,u_canc,u_oral From
> abstract2,registration2a,registration2b
> Where r_rid = u_rid and a_rid = u_rid and a_cdts < 1046077200 and
> r_fee <> 5  and r_fee <> 6 and u_canc = '' and u_oral = ''
> Order by r_lna,r_fna

Hi Robert,

Check that you group fields from one table together!
Most probably this is source of problem.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------