It is imposible reg_meeid to be CAMEX2000 AND CAMEX2001 AND... at the same time. Instead of AND use OR, or:
sele reg_masid,reg_meeid,reg_candt from regist ;
where empty(reg_candt) OR;
INLIST(reg_meeid,"CAMEX2000","CAMEX2001",CAMEX2002","CAMEX2003","CAMEX2004") ;
Group by reg_masid,reg_meeid ;
Order by reg_masid,reg_meeid ;
Into Cursor cTemp
>Hi All:
> I need help quickly. I want to sele all the record from a given table. When I execute the following code I get 0 records and I know there are at least 100 records. What am I doing wrong?
>
>sele reg_masid,reg_meeid,reg_candt from regist ;
>where empty(reg_candt) ;
> and reg_meeid = "CAMEX2000","CAMEX2001" ;
> and reg_meeid = "CAMEX2002" ;
> and reg_meeid ="CAMEX2003" ;
> and reg_meeid = "CAMEX2004" ;
> Group by reg_masid,reg_meeid ;
> Order by reg_masid,reg_meeid ;
> Into Cursor cTemp
>I know that there are records matching all the four requirements. Why am I getting 0 records than?
>Thanks
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.