recordcount question

[Gregory Kowalski]

Hi,

Using V4MD 2 MAC.

The following query gives me 3 results, but "recordcount" only returns 
1.

Why won't recordcount return 3?




   query = "select * from atable, btable, ctable where afield = bfield 
and bfield = cfield and afield = 1000"

   gmycursor = gdb.sqlselect(query)
   put gmycursor.recordcount                         -- 1
   put gmycursor.field("afield").getstring()     --1000
   put gmycursor.field("bfield").getstring()     --1000
   put gmycursor.field("cfield").getstring()     --1000


Thanx


Greg