SELECT isisn.*,company.companyName,cycle.bcName,month.monthName,year.year
FROM isisn,company,cycle,month,year
WHERE (isisn.companyID = company.companyID AND isisn.monthID = month.monthID) AND (isisn.yearID = year.yearID AND isisn.bcID = cycle.bcID) AND isisn.companyID LIKE '%colname' AND isisn.monthID LIKE '%colname2' AND isisn.yearID LIKE '%colname3'