The data window take DBname problem!-CodePudding

My data window in the select statement is useful to the table alias "select col1, col2 from table1 t1", is to take out when take col1 dbname table1. The col1 rather than t1. Col1, if I want to be in the original SQL statement used to add the where condition, there is no way to add dbname (plus the where table1. The col1='1' complains, must be the where t1, col1='1'), what method can take t1, col1?

CodePudding user response:

refer to the original poster tiantanglyz response:

my data window in the select statement is useful to the table alias "select col1, col2 from table1 t1", is to take out when take col1 dbname table1. The col1 rather than t1. Col1, if I want to be in the original SQL statement used to add the where condition, there is no way to add dbname (plus the where table1. The col1='1' complains, must be the where t1, col1='1'), what method can take t1, col1?

Take less than, for t1 pseudo name of the table, there is no such thing as in the database, unless you build a view, the name for the t1

CodePudding user response:

Upstairs, positive solutions

CodePudding user response:

reference 1st floor lzp_lrp response:

Quote: refer to the original poster tiantanglyz response:

My data window in the select statement is useful to the table alias "select col1, col2 from table1 t1", is to take out when take col1 dbname table1. The col1 rather than t1. Col1, if I want to be in the original SQL statement used to add the where condition, there is no way to add dbname (plus the where table1. The col1='1' complains, must be the where t1, col1='1'), what method can take t1, col1?

Take less than, for t1 pseudo name of the table, there is no such thing as in the database, unless you build a view name for t1

Is there any way to get to