[RBASE-L] - Maybe its the weather...

[Dick Fey]

This works:

Select StNumber from temp1 where StNumber = 'A1234'


This works:

Select StyleNum from VenPrice where StyleNum =  'A1234'


This DOES NOT work:

Select * from VenPrice where StyleNum in (select StNumber from temp1)


What am I missing?