Help with Join Query

[datoshway]

The following is querying one table.  I need this to query two tables and display the results.

 

$strQuery			= "SELECT * FROM tblDocuments ORDER BY dtAdded DESC";
$queryGetNews		= db_query($strQuery);

 

 

[Adam]

What kind of JOIN? What other table? Which columns are related?

[datoshway]

The related column is strMessage.  Basically need to pull strMessage from both tables.

[fenway]

SELECT * FROM tblDocuments INNER JOIN theOtherTable ON ( theOtherTable.strMessage = tblDocuments.strMessage ) ORDER BY tblDocuments.dtAdded DESC"

[datoshway]

Thank you!  For some reason i'm only getting two results from one table with that query.  There should be 3 results if we were getting data from both tables.  Below is my full code.  Any ideas on where the snag might be?

 

$strQuery			= "SELECT * FROM tblDocuments INNER JOIN tblCleaning ON ( tblCleaning.strMessage = tblDocuments.strMessage ) ORDER BY tblDocuments.dtAdded DESC";
$queryGetNews		= db_query($strQuery);

 

 <?php
							if (db_num_rows($queryGetNews) > 0) {
								while ($objRow = db_fetch_object($queryGetNews)) {
									$intRowID		= intval($objRow->intID);
									$strRowName		= stripslashes($objRow->strHeadline);
									$strMessage		= stripslashes($objRow->strMessage);
									$dtAdded	= date("m/d/Y", strtotime($objRow->dtAdded));
									?>


									<div id="messages" style="border:1px solid #999; width:430px; height:26px; line-height:26px; margin-bottom:3px; padding-left:5px;"><?php echo $dtAdded; ?> - <?php echo $strMessage; ?></div>


									<?php
								}
								db_free_result($queryGetNews);
							}
						?>

[fenway]

I don't need to see you code, I need to see you data.

[datoshway]

huh?

[fenway]

You're telling me the database is wrong.

 

I'm telling you to show me the 3 records from each table that match on strMessage.