SQL: select s.ID,s.STOCKCODE,s.STOCKNAME,s.STOCKBRANDID,s.STOCKMODELID,s.STOCKDESCRIPTION,s.WEBDESCRIPTION,s.ISSTOCKBODY,s.ISSTOCKCOLOR,sb.STOCKBRANDNAME,sm.STOCKMODELNAME from STOCK s LEFT JOIN STOCKBRAND sb ON sb.ID=s.STOCKBRANDID LEFT JOIN STOCKMODEL sm ON sm.ID=s.STOCKMODELID where s.ID=:ID and s.ISACTIVE=:ISACTIVE and s.ISDELETED=:ISDELETED
SQL Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 's.ISSTOCKBODY' in 'field list'
PRODER E-TİCARET

0 Yorum | Yorum Yaz


Kodu :



SQL: select count(*) as count from STOCK,STOCK where ID=:ID and ISDELETED=:ISDELETED and ISACTIVE=:ISACTIVE and ID=:ID limit 1
SQL Error: SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'STOCK'

Önerilen Ürünler