topic simple join question in QlikView https://community.qlik.com/t5/QlikView/simple-join-question/m-p/1145260#M904317 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I'm having troubles doing an outer join, I thought I understood and it's easy but I get an error. I want to do an outer join for Table1 and 2. These tables have a key that make them connected to each other, but now I want to have everything from the two tables in one NewTable and then drop the first two tables. Below gives me an error </P><P></P><P>NewTable:</P><P>outer join(Table1)</P><P>load * from Table2;</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z simple join question https://community.qlik.com/t5/QlikView/simple-join-question/m-p/1145260#M904317 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I'm having troubles doing an outer join, I thought I understood and it's easy but I get an error. I want to do an outer join for Table1 and 2. These tables have a key that make them connected to each other, but now I want to have everything from the two tables in one NewTable and then drop the first two tables. Below gives me an error </P><P></P><P>NewTable:</P><P>outer join(Table1)</P><P>load * from Table2;</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/simple-join-question/m-p/1145260#M904317 2020-11-25T16:16:04Z Re: simple join question https://community.qlik.com/t5/QlikView/simple-join-question/m-p/1145261#M904318 <HTML><HEAD></HEAD><BODY><P>oh I need to use load * resident and not from!!!! Apologies</P></BODY></HTML> Wed, 29 Jun 2016 19:14:09 GMT https://community.qlik.com/t5/QlikView/simple-join-question/m-p/1145261#M904318 2016-06-29T19:14:09Z