Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
michaelsmith
Contributor III
Contributor III

Duplicate Table Name Within From Statement

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?

3 Replies
Not applicable

Hi Michael,

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

Thanks,
Sreeman

Anonymous
Not applicable

Which database or data source?

vikasmahajan

It could be  this

SELECT x,y,z

FROM  DBname.TableName

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.