SQL question

[Steve Albin]

On Thursday, April 5, 2007 bart.pietercil at gmail.com (Bart Pietercil) wrote:

>On 4-apr-07, at 23:51, Steve Albin wrote:
>
>> I have the following SQL:
>>
>> SELECT Sessions.dSessDate, types.cTypeName, Sessions.cCity,  
>> Sessions.nSessId
>> FROM Sessions, Labels, Types
>> WHERE Sessions.nLabelId =  5
>> AND Sessions.SessType = Types.nId
>> ORDER BY Sessions.dSessDate
>
>Quick guess
>
>you are using types and Types mixed. MAybe this is more strict than  
>it was ?
>

Nice try.  I tested in VStudio with consistent case and it didn't matter.  Error both ways.

Thanks,

Steve

-- 
Steve Albin - Montclair, NJ
http://www.jazzdiscography.com/
http://www.steve-albin.com/