mysql SQL statement help

Anon

I want to select W and X from extra_table, and A, B and C from home_table in the same SQL statement.

How do I do that?

Is it "join"? Is MySQL compatible with that?

Pseudo Code:
SELECT
A.home_table,
B.home_table,

C.home_table,

W.extra_table,
X.extra_table
WHERE ID = 434

Anon

Classic join:
SELECT t1.id, t1.a, t1.b, t1.c, t2.id, t2.x, t2.y
FROM table1 AS t1, table2 AS t2
WHERE t1.id = t2.id;

If that is what you want the above should do the trick. If both tables don't have a corresponding "ID" then you shouldn't call them both in the same SQL query because you will get overlapping data in the results. If you want to do it so that you get all that data when ID = 434 then change the where statement to
WHERE t1.id = t2.id AND t1.id = '434'

HTH
Justin

Anon

I realized that the "two" queries didn't have anything in common.
All I wanted to do was to save some time:
Instead

$productinfo_query = "SELECT product_name,business_or_home,USB_or_Ethernet FROM product_table WHERE productID = '$productID'";
$productinfo_result = mysql_query($productinfo_query,$mysql_link) or die(ErrorHandler_function(mysql_error(),77));
$fetch_productinfo = mysql_fetch_array($productinfo_result);

	if ($extraID != '')
	{
		$extrainfo_query = "SELECT extra_name FROM extra_table WHERE extraID = $extraID";
		$extrainfo_result = mysql_query($extrainfo_query,$mysql_link) or die(ErrorHandler_function(mysql_error(),83));
		$fetch_extrainfo = mysql_fetch_array($extrainfo_result);
	}

I wanted to do it in one single mysql_query()!

Anon

But unless the two tables are related you will have problems. Let's say you have two completely unrelated tables, table one, which has two columns with the following records:
Col1 Col2
==== ====
A AA
B BB
C CC

And you have another table with the follwoing two columns:
Col1 Col2
==== ====
1 11
2 22
3 33
4 44
5 55

And you run the query
SELECT t1.col1, t1.col2, t2.col1, t2.col2
FROM table1 AS t1, table2 AS t2;

You will get:
T1.col1 T1.col2 T2.col1 T2.col2
======= ======= ======= =======
A AA 1 11
B BB 2 22
C CC 3 33
C CC 4 44
C CC 5 55

You see how the C and CC's overlap because it reached the end of the records for table1 but not for table2. This is bad format for SQL queries...

Justin

Anon

Does mysql support the UNION statement? In lots of other SQL dialects, you can concatenate the output of two queries like this:
select field1 from table1
UNION
select field2 from table2

Assuming field1 and field2 are the same data type.

Anon

Justin Kohlhepp wrote:

This is bad format for SQL queries...

I've learned something new then.