C
carl
I am trying to find a querry that will exclude a line of data if the
UnderlyingSymbol is in the list and the TradeType is Pip.
I tried this but to no avail
SELECT BTA_Trades_April.*
FROM BTA_Trades_April
WHERE UnderlyingSymbol NOT IN
('A','AA','AAPL','AIG','AMD','AMGN','AMZN','BAC','BMY','BSC','C','CAT','CFC','COP','CSCO','DELL','DIA','DNDN','EBAY','EEM','EMC','F','FCX','FLEX','GE','GM','GS','HAL','HD','INTC','IWM','JAVA','JPM','LEH','MER','MNX','MO','MOT','MSFT','NEM','NYX','OIH','PFE','QCOM','QQQQ','RIMM','RIO','SBUX','SMH','SNDK','SPY','T','TGT','TXN','VLO','VZ','WFMI','WM','WMT','XLE','XLF','XOM','YHOO')
and TradeType<>'Pip';
Thank you in advance for your help.
UnderlyingSymbol is in the list and the TradeType is Pip.
I tried this but to no avail
SELECT BTA_Trades_April.*
FROM BTA_Trades_April
WHERE UnderlyingSymbol NOT IN
('A','AA','AAPL','AIG','AMD','AMGN','AMZN','BAC','BMY','BSC','C','CAT','CFC','COP','CSCO','DELL','DIA','DNDN','EBAY','EEM','EMC','F','FCX','FLEX','GE','GM','GS','HAL','HD','INTC','IWM','JAVA','JPM','LEH','MER','MNX','MO','MOT','MSFT','NEM','NYX','OIH','PFE','QCOM','QQQQ','RIMM','RIO','SBUX','SMH','SNDK','SPY','T','TGT','TXN','VLO','VZ','WFMI','WM','WMT','XLE','XLF','XOM','YHOO')
and TradeType<>'Pip';
Thank you in advance for your help.