SQL Server likes this query, but FoxPro doesn't. Foxpro gives
Function name is missing ).
Anybody know how to reword it to work?
select rtrim(clients.fname)+rtrim(' '+clients.mname)+' '+rtrim(clients.lname) as fullname, (select top 1 plans.effective from plans where plans.clientno=clients.clientno and plans.effective>date() order by plans.effective) as meetdate, (select top 1 plans.meet_time from plans where plans.clientno=clients.clientno and plans.effective>date() order by plans.effective) as meettime from clients into table formlet2 order by clients.lname, clients.fname, clients.mname, clients.clientno
Randy Hersom
President, Habilitation Software Inc.