/* CREATE EVERYTHING.. */
USE `test`;
DROP TABLE IF EXISTS `company`;
DROP TABLE IF EXISTS `ticket`;

CREATE TABLE `company` (company_name VARCHAR(100), `date` VARCHAR(100), `ticket_id` INT, `company_id` INT);
CREATE TABLE `ticket` (`company_id` INT, `ticket_id` INT, duration INT);

/* INSERT VALUE */
INSERT INTO `company` VALUES
  ('A-Gen', 'January 1, 2008', NULL, 1),
  ('A-Gen', 'January 1, 2009', 5, 1),
  ('T-Aro', 'July 1, 2008', 7, 2),
  ('T-Aro', 'July 1, 2009', NULL, 2);

INSERT INTO `ticket` VALUES
  (1,5,120), (2,7,150);

/* THE QUERY */
SELECT c.company_name, c.date, t.ticket_id, t.duration
FROM `company` c
LEFT JOIN `ticket` `t` ON `t`.`company_id`=`c`.`company_id` AND `t`.`ticket_id`=`c`.`ticket_id`;

Result:
company_name    date    ticket_id       duration
A-Gen   January 1, 2008 NULL    NULL
A-Gen   January 1, 2009 5       120
T-Aro   July 1, 2008    7       150
T-Aro   July 1, 2009    NULL    NULL