--Step 1: in Teradata Sql Assistant, I create a volatile table as shown below.
--Step 2: I do "select from customer" and I get "ambiguous error"
--Q: How do I specify to make the SELECT get it from Volatile-Land? Otherwise I end up making fake names like "bueler_customer" to make it work... Thanks! You guys are the best!
create volatile set table customer as (selectcst.cust_acct_nbrfromprod_db.customer cst)with dataprimary index (cust_acct_nbr)on commit preserve rows;