two table query

[fallenAristo]

Hello,

I've inherited a db that has no relationships between tables.

I need to query two separate tables and merge them into one array - It can be a PHP array or a mySQL array.

Whats the best way to do this - will it need two separate queries to the db?

TIA, TTFN

[ultraslacker]

If there is nothing to join on, then it will have to be separate queries. And arrays usually have common elements - not sure how merging disparate resultsets into one array will help you.

[Elizabeth]

You can do it in one query but I'm not sure if it will give you results in a usable, organized format...

$query = "SELECT table1.varname, table2.varname FROM table1, table2";

This will give you every possible combination of values, but it might help see what's in there, anyway.

hth
-Elizabeth

[arelgee]

I don't get what you mean by putting them into an array. What purpose would that serve?
I think you mean you need to combine two different tables into one table.
Without knowing more, I would say to write a table with fields that include both tables, append the first table into it, and then update the second table into that.
Depending on what platform the original tables are in, you could alter the one with the most data in it to include the fields of the second, but that would be tricky and hard to do.

Without knowing more I cannot give you any hints on actual code.
arelgee

[dspeer]

Here's one that I use... My tables have alike ID values... One has a customer's information and then an ID for that customer which references all actions in a Journal for that customer... It's a pretty hairy query but does exactly what I want it to do:
$result = mysql("$DBName","SELECT tblDCJournal.*, tblCustomerDetail.customerlong, tblSupplyDCTech.DCTechLastName,
tblSupplyStatusOptions.Value, tblSupplyOwners.OwnerLastName, DATE_FORMAT(TimeDate, '%m-%d %H:%i')
FROM tblDCJournal
LEFT JOIN tblCustomerDetail ON tblDCJournal.CustomerID = tblCustomerDetail.customerID
LEFT JOIN tblSupplyDCTech ON tblDCJournal.DCTechID = tblSupplyDCTech.DCTechID
LEFT JOIN tblSupplyStatusOptions ON tblDCJournal.OpenIssue = tblSupplyStatusOptions.ID
LEFT JOIN tblSupplyOwners ON tblDCJournal.Owner = tblSupplyOwners.ID
WHERE tblDCJournal.TimeDate >= DATE_SUB(NOW(),INTERVAL '1' DAY)
ORDER BY tblDCJournal.TimeDate DESC") or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
$customerID= $row[0];
$timeanddate = $row[1];
$dctechID = $row[2];
$openissue = $row[3];
$jobID = $row[4];
$notes = $row[5];
$calendarID = $row[6];
$owner = $row[7];
$closetime = $row[8];
$customerlong = $row[9];
$DCTechLastName = $row[10];
$status = $row[11];
$ownername = $row[12];
$timedate = $row[13];

echo "whatever i am saying for this record... insert variables here."