mysql-error-1051

'Unknown table' although it really exists

$query = mysql_query("SELECT company.*, factory.* FROM company FULL JOIN factory ON company.n_id = factory.n_id WHERE company.n_id = '$n_id' AND factory.n_id = '$n_id'") or die(mysql_error()); Above you see my query. It gives me Unknown table 'comp...

Error with my left joins?

I'm thinking the coffee isn't strong enough today. I need to query the table fb-celebotd to get the photoid that matches the fb-celebotd.celebdate. Most of the other info needed is dependent on the photos table. The following is giving me a mysql error: Select photos.*,photographer.name, events.eventname, events.eventhome, subevents.su...