How can I left inner join two tables?

How can I join two tables, with different numbers of rows, using a key that exists in both tables but as the result I want to have the entire left table with attached right one. I am looking for something like 'Type' 'leftouter' that existed in dataset structure