Selecting multiple value from one column in multiple columns

See more:

SQL

SQL-Server-2008R2

Dears,

I was having 2 tables like this:

Products:
ID----Cost
=======
1-----5.00
2-----3.00

ProductsLanguage:
ProductID----LanguageID----Description
=========================
1--------------1---------------Pepsi
1--------------2---------------بيبسى
2--------------1---------------CocaCola
2--------------2---------------كوكاكولا

Now I want the output as follows:

Output:
ProductID---Cost---EnglishDescription---ArabicDescription
=====================================
1------------5.00----Pepsi-----------------بيبسى
2------------3.00----CocaCola-------------كوكاكولا


Please tell me the appropriate query for doing so.

Thank you
:)