Super easy question but I just can't seem to find the syntax error.
I'm getting the error "SQLSTATE[42S02]: Base table or view not found: 1146 Table 'techatco_mage.t' doesn't exist"
from the query attached. For some reason it is taking the alias as the table.
Could anyone help? Thanks much.
$sqry = "select t.topic_id from ".$faqsTopicTable." t,".$faqsStoreTable." s WHERE t.default='1'
and t.topic_id = s.topic_id
and s.store_id= ".Mage::app()->getStore()->getId()."
order by update_time desc limit 1;";