Group by cast

PAscal
2011-12-01
2013-04-15
  • PAscal
    PAscal
    2011-12-01

    Hello,
    statements like

    select  cast(T2.a as integer) , count(*)
    from A T1, B T2
    group by  cast(T2.a as integer)

    returns message
    Use table.field instead of integer!

    Regards
    PAscal