Selecting from two tables

[webmasternovis]

Hi all,

I want to select data from two tables, and order it through a date field. I'd normally not have a problem doing this as I'd just join them, but there isn't a column to link the two tables together. Does anyone know if this is possible? I want to select fields matching x in one table, and matching something else in the other. The main issue is ordering them all by the date though.

Thanks,
Mike

[leatherback]

If there is no colum that links the two tables I'd say there is no option. Howeverm if all you are after is an ordered list of information, why not select the records the two tables into an array, and sort the array?

[webmasternovis]

That sounds the best way, yeah. Does anyone know how I could achieve this? I have the following at the moment but it doesn't work.

for ($c=0; $c < mysql_num_rows($getmessages); $c++)
		{
	$gmrow = mysql_fetch_assoc($getmessages);
	$gettogether .= array($gmrow[subject]) . ",";
		}
		$new = array($gettogether);
		print_r($new);

Thanks,
Mike

[laserlight]

You may be able to do a:

SELECT col_x AS data, `date` FROM table1
UNION
SELECT col_y AS data, `date` FROM table2

but why is there no foreign key involved in the first place?