[gsnindia]

getting this erro please help

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT ticket.*, user.username AS assignedtechusername
,icon.title AS icontitle, icon.iconpath
FROM ticket AS ticket
LEFT JOIN user AS user ON (user.userid = ticket.assignedtechid)
LEFT JOIN icon AS icon ON(icon.iconid = ticket.iconid)
WHERE postuserid = 1 AND open = 1
ORDER BY replydateline DESC
LIMIT 0, 20;

MySQL Error : Unknown column 'ticket.assignedtechid' in 'on clause'
Error Number : 1054