ID doesn't show in queries Base

I have a query that contains the ID #. When doing the query the ID remains 0 even though I have 8,000 records.
Is this how it works?

Hello,

You consistently do not provide much information when posting a question - OS, LO version, database used. In this particular case, the actual SQL you are using would help and what it is to accomplish. Often a sample .odb is useful.

People want to help but at least some basic information is necessary.

In all probability, it’s most likely the design of the Query causing the problem.