I don't see anything wrong with it. How do you know that requery doesn't work?

>
>SELECT Company.orgname, Company.statecorpi, Company.stateoforg,;
> Company.fiscyrend, Company.orgdate, Company.citybuslic,;
> Company.countybusl, Company.statebusli, Licenses.licenseid,;
> Licenses.companyid, Licenses.code, Licenses.filingfee, Licenses.statetax,;
> Licenses.agency, Licenses.address1, Licenses.address2, Licenses.city,;
> Licenses.postal, Licenses.county, Licenses.country, Licenses.phone,;
> Licenses.internatio, Licenses.intadd, Licenses.type, Licenses.dt1,;
> Licenses.dt2, Licenses.dt3, Licenses.dt4, Licenses.dt5, Licenses.dt6,;
> Licenses.dt7, Licenses.dt8, Licenses.dt9, Licenses.dt10, Licenses.dt11,;
> Licenses.dt12, Cmstates.state, Licenses.citylic, Licenses.countylic,;
> Licenses.statelic, Licenses.foreignlic, Licenses.otherlic,;
> Licenses.dtype, Licenses.taxidno, Company.companyid, Cmstates.code,;
> Company.stateofind,;
> IIF(Licenses.dtype=1,Licenses.dt4,IIF(Licenses.dtype=2,Licenses.dt5,IIF(Licenses.dtype=3,Licenses.dt2,IIF(Licenses.dtype=4,Licenses.dt1,DATE())))) AS firstdt,;
> PADR(IIF(Licenses.dtype=1,"Annual",IIF(Licenses.dtype=2,"Semiannual",IIF(Licenses.dtype=3,"Quarterly",IIF(Licenses.dtype=4,"Monthly","No Data")))),12) AS datetype;
> FROM ;
> nch_mgr!company ;
> INNER JOIN nch_mgr!licenses ;
> ON Company.companyid = Licenses.companyid ;
> LEFT OUTER JOIN nch_mgr!cmstates ;
> ON Licenses.code = Cmstates.code;
> WHERE Company.companyid = ( ?zcompany );
> ORDER BY Company.orgname, Licenses.licenseid