>

select ...
>   tbl1.field_value as padmis,;
>   tbl2.field_value as adpriv ;
>   left outer join table_add_detail as tbl1 ;
>      on .. = tbl1.unique_id and tbl1.field_name = "padmis" ;
>   left outer join table_add_detail as tbl2 ;
>      on .. = tbl1.unique_id and tbl1.field_name = "adpriv" ;
> '''

David,

It looks like the clue I needed is in the above syntax. I'll give it a shot later this morning and let you know how I made out! Thanks for your help man.