Getting data from two tables
Actually I have resolved my own problem. My problem was that the query was taking too long to display data and this problem came from my join to a view! After I found the tables that were creating the view I extracted the one were I found my needed columns and used it in my join. 
Probably the problem in joining views is with indexes. I need to read more about indexing a view but I suspect that this was my problem.