Duplicate Table Name Within From Statement

[michaelsmith]

I'm working on a QWV created by someone else and it's doing something I've never seen before.

The application extracts records from a database using code similar to the follow:

SELECT x,y,z

FROM TABLE_NAME TABLE_NAME

I don't understand what the repetition of the table name is doing?  If I simplify it to the following code less records are extracted.

SELECT x,y,z

FROM TABLE_NAME

Can anyone shed any light on why this is the case?

[#2]

Hi Michael,

I think it might be the alias name of the table name

Thanks,
Sreeman

[Anonymous]

Which database or data source?

[vikasmahajan]

It could be  this

SELECT x,y,z

FROM  DBname.TableName

Vikas