# Error "Query fileds is missing alias" in a Machine Step

**URL:** <https://forum.novacura.com/t/error-query-fileds-is-missing-alias-in-a-machine-step/593>\
**Category:** Flow Classic\
**Created:** [December 20, 2023, 9:42pm UTC](https://forum.novacura.com/t/error-query-fileds-is-missing-alias-in-a-machine-step/593 "2023-12-20T21:42:04Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jose.Mario.Pites](https://avatars.discourse-cdn.com/v4/letter/j/7C9FD7/32.png) [@Jose.Mario.Pites](https://forum.novacura.com/u/Jose.Mario.Pites)\
**Post date:** [December 20, 2023, 9:42pm UTC](https://forum.novacura.com/t/error-query-fileds-is-missing-alias-in-a-machine-step/593/1 "2023-12-20T21:42:04Z")

</div>

Hello.

I am getting that error in SQL queries that are executed without any error in Azure Studio. Anyone has a clue why is that happening?

The SQL command is the following:

```auto
SELECT CodSistem as CodSis, CodObjeto as CodObj
, TRIM(ISNULL(DscObjeto,'')) as Descri
FROM mwwSIRESP.dbo.Objectos ORDER BY CodSistem

```

---

<div class="post-metadata">

**Author:** ![daniel](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.novacura.com/daniel/32/708_2.png) [@daniel](https://forum.novacura.com/u/daniel)\
**Post date:** [December 21, 2023, 4:21am UTC](https://forum.novacura.com/t/error-query-fileds-is-missing-alias-in-a-machine-step/593/2 "2023-12-21T04:21:12Z")

</div>

Try using quotes (") around your column name in leu of using the “as” declaration like so:

```sql
SELECT CodSistem "CodSis", CodObjeto "CodObj", TRIM(ISNULL(DscObjeto,'')) "Descri"
FROM mwwSIRESP.dbo.Objectos 
ORDER BY CodSistem

```

---

<div class="post-metadata">

**Author:** ![Jose.Mario.Pites](https://avatars.discourse-cdn.com/v4/letter/j/7C9FD7/32.png) [@Jose.Mario.Pites](https://forum.novacura.com/u/Jose.Mario.Pites)\
**Post date:** [December 21, 2023, 8:03am UTC](https://forum.novacura.com/t/error-query-fileds-is-missing-alias-in-a-machine-step/593/3 "2023-12-21T08:03:57Z")

</div>

It worked! Thank you very much.