sql server - SQL error: The multi-part identifier could not be bound -

i have sql query:

select contactid, items.name, orders.confirmed, deleted, dbo.polish_date(orders.crdate), orders.orderid, idtowar, idspecial, idstatus, idtype, description  orders, items left join contacts on orders.orderid = idorder  (orders.iduser='38824' , orders.idtowar=items.itemid)  order orders.crdate 

and have error every time:

the multi-part identifier "orders.orderid" not bound.

try this

select contactid, items.name, orders.confirmed, deleted, dbo.polish_date(orders.crdate), orders.orderid, idtowar, idspecial, idstatus, idtype, description  orders  left join contacts on orders.orderid = idorder  left join items on orders.idtowar = items.itemid orders.iduser='38824' order orders.crdate