Military2
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 5 articles for 0.000 sec
Re: Group by clause     

Group: microsoft.public.fox.vfp.queriessql · Group Profile · Search for Military2 in microsoft.public.fox.vfp.queriessql
Author: Cindy Winegarden
Date: Mar 26, 2007 08:52

... 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart, military2 as tEnd,orno as Croom, ; cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as cdsc,CRANGGRPID as rangegroupid ; FROM staffdtl ; WHERE staffid = "...
Show full article (2.36Kb)
Re: Group by clause     

Group: microsoft.public.fox.vfp.queriessql · Group Profile · Search for Military2 in microsoft.public.fox.vfp.queriessql
Author: apa
Date: Mar 26, 2007 08:49

... version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart, military2 as tEnd,orno as Croom, ; cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as cdsc,CRANGGRPID as rangegroupid ; FROM staffdtl ; WHERE staffid = "XXX...
Show full article (2.01Kb)
Re: Group by clause     

Group: microsoft.public.fox.vfp.queriessql · Group Profile · Search for Military2 in microsoft.public.fox.vfp.queriessql
Author: Cindy Winegarden
Date: Mar 23, 2007 08:38

...but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart, military2 as tEnd,orno as Croom, ; cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as cdsc,CRANGGRPID as rangegroupid ; FROM staffdtl ; WHERE staffid = "XXX" ;...
Show full article (1.68Kb)
Re: Group by clause     

Group: microsoft.public.fox.vfp.queriessql · Group Profile · Search for Military2 in microsoft.public.fox.vfp.queriessql
Author: apa
Date: Mar 22, 2007 10:20

..., but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart, military2 as tEnd,orno as Croom, ; cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as cdsc,CRANGGRPID as rangegroupid ; FROM staffdtl ; WHERE staffid = "XXX" ; ...
Show full article (0.76Kb) · Show article thread
Group by clause     

Group: microsoft.public.fox.vfp.queriessql · Group Profile · Search for Military2 in microsoft.public.fox.vfp.queriessql
Author: apa
Date: Mar 22, 2007 09:54

... it, but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as Dend, military1 as tStart, military2 as tEnd,orno as Croom, ; cweeks as cWeeks, cDays as Cdays, laway as laway, cawaydsc as cdsc,CRANGGRPID as rangegroupid ; FROM staffdtl ; WHERE staffid = "XXX" ; GROUP BY ...
Show full article (0.54Kb)