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