I'm new to Teradata. I have a table with millions of records and I am trying to query based on a subset using a lookup list to feed my where clause.
My lookup list contains thousands of records.
In SQL Assistant this is what I've tried:
SELECT T.* FROM a_balance TJOIN OPENROWSET ( BULK 'c:\myfile.txt', FORMATFILE = 'c:\myfileformat.txt' ) B ON T.accountID = B.accountID
What would you recommend to do in Teradata SQL Assistant?
Solved! Go to Solution.
I guess you meant 'SQL Server'.
Your best bet should be to load your filter file into a table and execute an ordinary JOIN.
Not SQL Server. Using SQL Assistant to query. I have read-only access to the tables and database. There is zero chance of getting write access due to the sensitive nature of the data. I'm just a lowly user.
Working on implementing the Volatile table now. The join is giving me fits.
I'm so new to SQL that this is getting over my head quickly. I wouldn't have any trouble if it were C.