Custom table

[Bob L]

Hi,

When I'm looking a query in design view, I see a table named T0, but I don't have any tables with that name in my object pane to the left.

Does any know where I can find the source of this table?

Many thanks.

 

[Joe4]

Is it a hidden table?
See: Use the Navigation Pane.

 

[xenou]

That might be an alias for another table. Can you put the query in SQL view and post the sql here? Or to test how this works you can add a table to the design pane that is already there and you will see it gets a new "name" when you put it there two times.

Edit: and agree ^ hidden tables are another possibility for why you wouldn't see it in the navigation pane...

 

[Bob L]

Is it a hidden table?
See: Use the Navigation Pane.

That might be an alias for another table. Can you put the query in SQL view and post the sql here? Or to test how this works you can add a table to the design pane that is already there and you will see it gets a new "name" when you put it there two times.

Edit: and agree ^ hidden tables are another possibility for why you wouldn't see it in the navigation pane...

It wasn't a hidden table ('tho that's a good trick to know!), but I found what it was with the SQL view.

Thanks a lot!

 

[Joe4]

It wasn't a hidden table ('tho that's a good trick to know!), but I found what it was with the SQL view.

So what was it? Was it as xenou said, an alias?

 

[Bob L]

So what was it? Was it as xenou said, an alias?

Exact, it was an alias.

 

[BlaisePascal]

set mode to SQL to view