title: Left outer join query
body: <p><img src="https://i.stack.imgur.com/deP9e.jpg" alt="in Image table - 1 is table with Primery key ID autonumber and DeclarationContentId as FK from another table. There are two column GrantedAmount and DeclaredAmount Identified by the another column AmountType. I want a left outer join query which will return me a for DeclartionContentId with GrantedAmount and DeclaredAmount togather in a single row extepecte output table shown below in the image"></p>
  
  <p>in Image table - 1 is table with Primery key ID autonumber and DeclarationContentId as FK from another table. There are two column GrantedAmount and DeclaredAmount Identified by the another column AmountType. I want a left outer join query which will return me a for DeclartionContentId with GrantedAmount and DeclaredAmount togather in a single row</p>