>Phoung-
>I don't see any obvious syntax problems (I probably am just still sleepy < s>). Have you tried pasting the command in the command window and running it? You might try simplifying it, and add pieces as you go. Also, if you want a specific column heading for calculated column (the MIN function), use the AS clause. For example: SELECT MIN(a,b,c) AS MinCalc...
>
>Once the SQL select works, you can add the CREATE SQL VIEW myView AS SELECT ... syntax to create the view in the DBC.
>
>HTH
>
>>Hi,
>>I've got Your mail, Thanks a lot.
>>Here a example of my SQL command
>>SELECT V_thop_b.ten_bao,;
>> MIN(V_thop_b.ck_from+V_thop_b.to_dk+V_thop_b.dauky-V_thop_b.cuoiky,;
>> V_thop_b.dauky,V_thop_b.cuoiky);
>> FROM fabaco!v_thop V_thop_b;
>> WHERE V_thop_b.ck_from >= 1;
>> AND V_thop_b.to_dk >= 1;
>> GROUP BY V_thop_b.ten_bao
>>
>>When I add expression MIN(,,) to selected field, I always get "MIN(,,)" in selected field (View designer put function MIN into "", even if I type MIN(2,1) and add to selected fields) . Can You help me. Thanks very much. Phuong
Hi Nancy:
Sorry for jumping in
I think the problem is that the MIN() fiction when used in a SQL SELECT groups upon grouped results, probably to determine the minimun of three columns an IIF() function could work:
Iif(V_thop_b.ck_from+V_thop_b.to_dk+V_thop_b.dauky_thop_b.cuoiky < V_thop_b.dauky, V_thop_b.ck_from+V_thop_b.to_dk+V_thop_b.dauky_thop_b.cuoiky ,V_thop_b.cuoiky) as mimimum;
Oscar
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only