topic Left Outer Join???? in QlikView https://community.qlik.com/t5/QlikView/Left-Outer-Join/m-p/198791#M57976 <HTML><HEAD></HEAD><BODY><P>How do i perform left outerjoin between these tables...?????</P><P>LOAD ID,<BR /> Name<BR />FROM<BR /><C><BR />(biff, embedded labels, table is Associate$);</C></P><P><BR />LOAD [Associate ID] as ID,<BR /> Role<BR />FROM<BR /><C><BR />(biff, embedded labels, table is Projects$);</C></P></BODY></HTML> Wed, 31 Mar 2010 11:08:16 GMT 2010-03-31T11:08:16Z Left Outer Join???? https://community.qlik.com/t5/QlikView/Left-Outer-Join/m-p/198791#M57976 <HTML><HEAD></HEAD><BODY><P>How do i perform left outerjoin between these tables...?????</P><P>LOAD ID,<BR /> Name<BR />FROM<BR /><C><BR />(biff, embedded labels, table is Associate$);</C></P><P><BR />LOAD [Associate ID] as ID,<BR /> Role<BR />FROM<BR /><C><BR />(biff, embedded labels, table is Projects$);</C></P></BODY></HTML> Wed, 31 Mar 2010 11:08:16 GMT https://community.qlik.com/t5/QlikView/Left-Outer-Join/m-p/198791#M57976 2010-03-31T11:08:16Z Left Outer Join???? https://community.qlik.com/t5/QlikView/Left-Outer-Join/m-p/198792#M57977 <HTML><HEAD></HEAD><BODY><P>Try something like this:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />Table1:<BR />LOAD ... ;<BR />LEFT OUTER JOIN (Table1)<BR />LOAD ...;<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P></P><P>rgds</P><P>Anita</P></BODY></HTML> Wed, 31 Mar 2010 11:59:32 GMT https://community.qlik.com/t5/QlikView/Left-Outer-Join/m-p/198792#M57977 Anonymous 2010-03-31T11:59:32Z