You write your query.
So you can see here, we did ZVIBERMESSAGE.ZTEXT,
ZVIBERMESSAGE.ZSTATE, ZVIBERMESSAGE.ZDATE
from ZVIBERMESSAGE.
The reason you want to put the table name in front
of the column IS so that if you have an issue,
it's easier for you to identify it.
If you are going to reach out to your SME,
please make sure you're giving them the table name in front
of it if you're having issues with your query
because it's easier for us to isolate what the problem is
that you're having it.
You don't have to do that.
But while you're learning to write queries,
it's best practices.
And I strongly recommend that.
So I'm going to go back into my query and do this.
So what I would do is I'm just going to copy this,
and I'm going to paste in front of each of these with a period.
And nothing changes, but do you notice
the colorization of the table matches?
Everything looks good.
The next thing we're going to do is rename our columns
if needed.
This one doesn't really require that.
I think it looks good with how it's worded.
But you definitely can do that.