joining tables

I'm having problems joining 3 tables to provide a 4th table in the correct
format. I believe I need a FULL OUTER JOIN but does not give the result that
I require.See below:

Example 1
Table: Names				Table: Friend
Name	Tel	email	PostCode		Name	friend	email
Jim	1	aa	I			Dave	yes	cc
Ted	2	bb	J			Will	yes	dd
Dave	3	cc	K			Zac	yes	ff
Will	4	dd	L			Byron	yes	gg	

Table: Details
Name	email	Town	PostCode
John	ee	A	M
Zac	ff	B	N
Byron	gg	C	O
Will	dd	D	L
Gary	hh	E	P
Ted	bb	F	J

Combined table: Result
Name	Tel	email	Town	PostCode	friend
Jim	1	aa		I
Ted	2	bb	F	J
Dave	3	cc		K		yes	
Will	4	dd	D	L		yes
John		ee	A	M
Zac		ff	B	N		yes
Byron		gg	C	O		yes
Gary		hh	E	P



Example 2
Table: Names				Table: Friend
Name	Tel	email	PostCode		Name	friend	email
Jim	1	aa	I			Gareth	yes	ii
Ted	2	bb	J			Tony	yes	jj
Dave	3	cc	K			Ken	yes	kk
Will	4	dd	L			Lloyd	yes	ll		

Table: Details
Name	email	Town	PostCode
John	ee	A	M
Zac	ff	B	N
Byron	gg	C	O
Gary	hh	E	P

Combined table: Result
Name	Tel	email	Town	PostCode	friend
Jim	1	aa		I
Ted	2	bb		J
Dave	3	cc		K			
Will	4	dd		L		
John		ee	A	M
Zac		ff	B	N		
Byron		gg	C	O		
Gary		hh	E	P
Gareth		ii				yes
Tony		jj				yes			
Ken		kk				yes	
Lloyd		ll				yes





--
Sent from: https://www.postgresql-archive.org/PostgreSQL-pgadmin-support-f2191615.html