select a.id_customer, a.firstname, a.lastname, a.address1, a.address2, a.postcode, a.city from pre3305_customer c, pre3305_address a, pre3305_customer_group g where c.id_customer = a.id_customer and g.id_customer = c.id_customer and g.id_group in (1,2,3);