query block has incorrect number of result columns

[Former Member]

Hi,

Can any one help me rectify this error "query block has incorrect number of result columns ". I got this error once I added a new field into the resultant field. I did not alter anything in the existing query.

Thanks,

Sharmele.

[Former Member · Accepted solution]

Can you provide a little more detail? Is the query a double query with a UNION ALL somewhere in it? If so you would need to add the field into the second half of the double query as well, into the SELECT clause.

Assuming you are familiar with SQL, when you do the query preview you should be able to easily see your mistake. If you are not very familiar with SQL, I highly recommend working with someone on your team that understands proper SQL structure.

Howie Wexler,

Crafty Systems Inc.

[Former Member · Accepted solution]

Thanks Howie.

I added an extra field in to the second half of the query and it works fine. Thanks again.

Sharmele.