Output only displays value if in both tables

[tarja311]

Hello all. I hope you can help me.

I have two tables, Table1 and Table2. When i submit a name from my form ( eg : jimmy ), 'jimmy' is inserted into both tables. Now this part is fine. In the output, it displays the data from both tables ( output: jimmy - jimmy )

The problem i am having lies in my sql statement i believe.

Basically, the way i have it now, it says, if 'jimmy' is in Table1 AND in Table2, output the results, otherwise forget it!

It does not output anything if 'jimmy' is in NOT in Table1 but IS in Table2, or vice versa.

My code :

$result = mysql_query("SELECT". 
				     "`TABLE1`.username,".
				     "`TABLE2`.username ".	
			FROM".
				     "`TABLE1`,".
				     "`TABLE2`".
			"WHERE".
				     "`TABLE1`.username = `TABLE2`.username ".
		"") or die(mysql_error());

Hopefully someone can guide me in the right direction.

thanks

-- tarja

 

[r937]

SELECT TABLE1.username
     , TABLE2.username
  FROM TABLE1
[b]LEFT OUTER[/b]
  JOIN TABLE2
    ON TABLE1.username = TABLE2.username
[b]UNION ALL[/b]    
SELECT TABLE1.username
     , TABLE2.username
  FROM TABLE1
[b]RIGHT OUTER[/b]
  JOIN TABLE2
    ON TABLE1.username = TABLE2.username

r937.com | rudy.ca

 

[feherke]

Hi

That way the names present in both tables will be listed twice. I think simple [tt]union[/tt] would be better.

Feherke.

http://rootshell.be/~feherke/

 

[r937]

oh, i am such an idiot ©

of course, i meant to say UNION, not UNION ALL



r937.com | rudy.ca