select a.firstname, a.lastname, a.address1, a.address2, a.postcode, a.city from pre3303_customer c, pre3303_address a, pre3303_customer_group g where c.id_customer = a.id_customer and g.id_customer = c.id_customer and g.id_group in (10); 