Hi, I'm trying to execute a SQL statement asking three tables on a DBI database connection. The database is a commertiale one (diff from MySQL) .... I think that my SQL statement is right :
my($stmt) = "select AS_QteSto from art F_ARTICLE,dep F_DEPOT,sto F_ARTSTOCK where art.AR_Ref='$code' and dep.DE_Intitule='$depot' and art.AR_Ref=sto.AR_Ref and dep.DE_No=sto.DE_No"; in spite of that I had : DBD::ADO::st execute failed: Can't execute statement 'select sto.AS_QteSto from art F_ARTICLE,dep F_DEPOT,sto F_ARTSTOCK where art.AR_Ref='3095562806099' and dep.DE_Intitule='Depot Rungis' and art.AR_Ref=sto.AR_Ref and dep.DE_No=sto.DE_No': -2147217900: OLE exception from "Microsoft OLE DB Provider for ODBC Drivers": [Simba][Simba ODBC Driver]Unknown table or correlation name [sto] in select list. Thankx, asma