Hi. I am working to implement a dataconnection between my C# application and an Sql Express database. Please bear in mind I have not worked with Sql queries before.

I have the following relevant tables:

ArticlesCommon ArticlesLocalized CategoryCommon CategoryLocalized

where ArticlesCommon holds language independent information such as price, weight etc.

This is the statement for now:

SELECT * FROM ArticlesCommon INNER JOIN ArticlesLocalized ON
ArticlesCommon.ID = ArticlesLocalized.ID 
WHERE ArticlesLocalized.Language = @language
ORDER BY ArticlesCommon.DateAdded

ArticlesCommon contains a category id for each row. Now, I want to use this to look up the localized information in CategoryLocalized and add it to the result, something like

SELECT *, CategoryLocalized.Name as CategoryName.

If I have gotten my point across, is this doable?

Thank you.