Skip to content

Unable to process more than 11 function columns in SELECT Query MySQL #17

@saklanipankaj

Description

@saklanipankaj
SELECT SUM(t1.a*t2.b), AVG(t2.a-t1.b), SUM(t2.b/t1.a), COUNT(t2.a+t1.b), AVG(t2.a*t1.b), SUM(t1.b-t2.a), COUNT(t2.a*t1.b), AVG(t2.a/t1.b),SUM(t1.b+t2.a), COUNT(t1.b/t2.a), AVG(t1.b-t2.a), SUM(b*t1.t2.a)
FROM t1, t2;

ERROR 13180 (HY000): Unknown column 't1.a' in 'field list'

Ambiguous Error Statement is returned when number of function columns exceed 11 in SELECT Query in MySQL.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions