SQL question

Bart Pietercil bart.pietercil at gmail.com
Wed Apr 4 17:00:01 CDT 2007


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 ?

hth

BArt



More information about the Valentina mailing list