[SOLVED] INNER JOIN

[SchweppesAle]

Hi,

 

I'm trying to learn how to use proper INNER JOIN Syntax so I can stop using so many WHERE(s). 

 

The following code is returning false though, so I think I must have screwed up the syntax

 

$banner_table = $prefix.'banner';
$client_table = $prefix.'faclient';


$Query = "SELECT $banner_table.startdate
	, $banner_table.enddate
	, $banner_table.clicks
	, $banner_table.maxclicks
	, $banner_table.clientid
	, $client_table.clientid AS CID
	, $client_table.contactname
	, $client_table.contactemail	
FROM $banner_table, $client_table
  INNER
JOIN $client_table
  ON $client_table.clientid = $banner_table.clientid";

	/*
$Mail_Sent = new Mail($Query);*/
$result = mysql_query($Query);
echo '<pre>';
echo print_r($Query);
echo '</pre>';

echo var_dump($result);

 

output:

SELECT jos_banner.startdate
	, jos_banner.enddate
	, jos_banner.clicks
	, jos_banner.maxclicks
	, jos_banner.clientid
	, jos_faclient.clientid AS CID
	, jos_faclient.contactname
	, jos_faclient.contactemail	
FROM jos_banner, jos_faclient
  INNER
JOIN jos_faclient
  ON jos_faclient.clientid = jos_banner.clientid1

bool(false) 

 

is it obvious? 

[cags]

Try...

 

$Query = "SELECT $banner_table.startdate
      , $banner_table.enddate
      , $banner_table.clicks
      , $banner_table.maxclicks
      , $banner_table.clientid
      , $client_table.clientid AS CID
      , $client_table.contactname
      , $client_table.contactemail   
   FROM $banner_table
  INNER
   JOIN $client_table
     ON $client_table.clientid = $banner_table.clientid";

[SchweppesAle]

wow, that worked...

 

I don't get it though, I thought you need to specify which tables you're retrieving the columns from.

[SchweppesAle]

*rolls shoulder*

 

oh well, thanks man. lol

[cags]

By JOIN'ing the second table you now have brought it into 'scope' with regards to selecting columns from it.