TalkPHP - View Single Post - Dozens of questions which I cannot find. v_v

wGEric · 01-31-2008, 07:50 PM

Quote:

Originally Posted by Orc

I think I figured out that Inner join can be used to combine data from other tables to make one table :D

Yes, also LEFT JOIN and RIGHT JOIN. You can also do SELECT queries within other queries (as pointed out by buggabill). There's also UNIONs to do two queries at once.

Code:

SELECT name FROM cia WHERE population > (SELECT population FROM cia WHERE name='United States');
SELECT * FROM t1 UNION SELECT * FROM t2 UNION SELECT * FROM t3;