[SOLVED] not unique table/alias???

[thefortrees]

Hi all -

 

This query works when I execute it from mysql command line, but it doesn't work when the PHP script is executing. The error it is giving me is Not unique table/alias: 'companies'. I would appreciate any help you can give.

 

if ($lob == 'all'){
		$query = "SELECT company, lob FROM companies, businesses" .
				"WHERE companies.businesses_businesses_id = businesses.businesses_id;";

		$result = mysql_query($query) or die(mysql_error());
		echo $result;
		return $result;
	}

 

My businesses table has the following fields:

businesses_id

lob

 

My companies table has several fields, some including:

company

businesses_businesses_id

 

 

[Corona4456]

No space between 'businesses' and 'WHERE'