SELECT *
  FROM [dbo].[StockQuote]
  INNER JOIN [dbo].[Stock] ON [Stock].ID = [StockQuote].StockID
WHERE Ticker like '%VXX%' OR Ticker like '%VXZ%'