Subsequently added columns not appearing in query table using Select *
Hi
I created a query table with below code.
Select *.A from Table A
At the time of saving this query, Table A had three columns- B, C and D. After saving the query, I added two custom formula columns- E & F.
I would have expected the original query would automatically fetch the new columns upon refreshing but it doesn't.
I'm not a software guy, so not sure if this is normal in SQL or a constraint in Zoho Reports.
Please help understand.