hi, I'm having trouble joining these two tables. Can someone point out my mistake?
Code:
$query = 'SELECT jos_keyword_keys.ID, jos_keyword_keys.Word, '
.'jos_keyword_keys.ClientID, jos_keyword_keys.Destination, jos_keyword_keys.StartDate, '
.'jos_keyword_keys.EndDate, jos_keyword_keys.StartTime, jos_keyword_keys.EndTime '
.'jos_keyword_clients.Client, jos_keyword_clients.ID AS CID, jos_keyword_clients.Contact '
.'FROM (jos_keyword_keys AND jos_keyword_clients) WHERE (CID = jos_keyword_keys.ClientID)';
$query = mysql_query($query);