INSERT INTO bookings (customer_id,staff_id,table_id,start_time,end_time,guests)
  SELECT c.id AS "customer_id",
         s.id AS "staff_id",
         t.id AS "table_id",
         '12 Nov 2005 18:00' AS "start_time",
         '12 Nov 2005 20:00' AS "end_time",
	 4 AS "guests"
    FROM customers AS c,
         staff as s,
         tables AS t
    WHERE (c.name = 'Mavis' AND
           s.name = 'Jaques' AND
           t.id = 4);

INSERT INTO bookings (customer_id,staff_id,table_id,start_time,end_time,guests)
  SELECT c.id AS "customer_id",
         s.id AS "staff_id",
         t.id AS "table_id",
         '14 Nov 2005 20:00' AS "start_time",
         '14 Nov 2005 22:00' AS "end_time",
	 4 AS "guests"
    FROM customers AS c,
         staff as s,
         tables AS t
    WHERE (c.name = 'Mavis' AND
           s.name = 'Claude' AND
           t.id = 2);

INSERT INTO bookings (customer_id,staff_id,table_id,start_time,end_time,guests)
  SELECT c.id AS "customer_id",
         s.id AS "staff_id",
         t.id AS "table_id",
         '20 Nov 2005 18:00' AS "start_time",
         '20 Nov 2005 20:00' AS "end_time",
	 3 AS "guests"
    FROM customers AS c,
         staff as s,
         tables AS t
    WHERE (c.name = 'Mavis' AND
           s.name = 'Claude' AND
           t.id = 5);

INSERT INTO bookings (customer_id,staff_id,table_id,start_time,end_time,guests)
  SELECT c.id AS "customer_id",
         s.id AS "staff_id",
         t.id AS "table_id",
         '20 Nov 2005 20:00' AS "start_time",
         '20 Nov 2005 22:00' AS "end_time",
	 4 AS "guests"
    FROM customers AS c,
         staff as s,
         tables AS t
    WHERE (c.name = 'Leigh' AND
           s.name = 'Claude' AND
           t.id = 5);

INSERT INTO bookings (customer_id,staff_id,table_id,start_time,end_time,guests)
  SELECT c.id AS "customer_id",
         s.id AS "staff_id",
         t.id AS "table_id",
         '20 Nov 2005 16:00' AS "start_time",
         '20 Nov 2005 18:00' AS "end_time",
	 2 AS "guests"
    FROM customers AS c,
         staff as s,
         tables AS t
    WHERE (c.name = 'Coulter' AND
           s.name = 'Ernie' AND
           t.id = 3);

INSERT INTO bookings (customer_id,staff_id,table_id,start_time,end_time,guests)
  SELECT c.id AS "customer_id",
         s.id AS "staff_id",
         t.id AS "table_id",
         '16 Nov 2005 14:00' AS "start_time",
         '16 Nov 2005 15:00' AS "end_time",
	 2 AS "guests"
    FROM customers AS c,
         staff as s,
         tables AS t
    WHERE (c.name = 'Coulter' AND
           s.name = 'Ernie' AND
           t.id = 1);

INSERT INTO bookings (customer_id,staff_id,table_id,start_time,end_time,guests)
  SELECT c.id AS "customer_id",
         s.id AS "staff_id",
         t.id AS "table_id",
         '20 Nov 2005 20:00' AS "start_time",
         '20 Nov 2005 22:00' AS "end_time",
	 2 AS "guests"
    FROM customers AS c,
         staff as s,
         tables AS t
    WHERE (c.name = 'Edwards' AND
           s.name = 'Ernie' AND
           t.id = 2);