@Entity
public class Affiliate implements Serializable {
   
    private int id;
    private List<Product> product = new ArrayList<Product>();
   
    /** Creates a new instance of Affiliate */
    public Affiliate() {
    }

    @GeneratedValue
    @Id
    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }
   
    @ManyToMany(fetch=FetchType.EAGER)
    @JoinTable(
        name="Product_Affiliate",
            joinColumns={@JoinColumn(name="affiliate_id")},
            inverseJoinColumns={@JoinColumn(name="product_id")}
    )
    @Fetch(value=FetchMode.JOIN)
    public List<Product> getProduct() {
        return product;
    }

    public void setProduct(List<Product> product) {
        this.product = product;
    }
   
}

@Entity
public class Product implements Serializable {

    private List<Affiliate> affiliates = new ArrayList<Affiliate>();
    private Set<Schedule> schedule = new HashSet<Schedule>();
   
    private int id;
    private String title;
    private double price;
    private int capacity;
    private boolean active;
   
   
    /** Creates a new instance of Product */
    public Product() {
    }
   
    @GeneratedValue
    @Id
    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    @ManyToMany(mappedBy = "product")
    public List<Affiliate> getAffiliates() {
        return affiliates;
    }

    public void setAffiliates(List<Affiliate> affiliates) {
        this.affiliates = affiliates;
    }

    @OneToMany(cascade=javax.persistence.CascadeType.ALL, mappedBy="product",fetch=FetchType.EAGER)
    @Fetch(value=FetchMode.JOIN)
    public Set<Schedule> getSchedule() {
        return schedule;
    }

    public void setSchedule(Set<Schedule> schedule) {
        this.schedule = schedule;
    }
   
}

@Entity
public class Schedule implements Serializable {
    private int id;
    private Date date;
    private Product product;
   
    /** Creates a new instance of Schedule */
    public Schedule() {
    }

    @GeneratedValue
    @Id
    public int getId() {
        return id;
    }

    protected void setId(int id) {
        this.id = id;
    }
   
    @ManyToOne(fetch=FetchType.EAGER)
    @JoinColumn(name="product_id", nullable=false)
    public Product getProduct() {
        return product;
    }
   
    public void setProduct(Product product) {
        this.product = product;
    }

}

EntityManager em = emf.createEntityManager();
Collection<Affiliate> colx = em.createQuery("select obj from Affiliate obj").getResultList();
em.close();
emf.close();

Hibernate: select affiliate0_.id as id4_, affiliate0_.contact as contact4_, affiliate0_.main as main4_, affiliate0_.title as title4_ from Affiliate affiliate0_
Hibernate: select product0_.affiliate_id as affiliate1_1_, product0_.product_id as product2_1_, product1_.id as id0_0_, product1_.price as price0_0_, product1_.capacity as capacity0_0_, product1_.active as active0_0_, product1_.title as title0_0_ from Product_Affiliate product0_ left outer join Product product1_ on product0_.product_id=product1_.id where product0_.affiliate_id=?
Hibernate: select product0_.affiliate_id as affiliate1_1_, product0_.product_id as product2_1_, product1_.id as id0_0_, product1_.price as price0_0_, product1_.capacity as capacity0_0_, product1_.active as active0_0_, product1_.title as title0_0_ from Product_Affiliate product0_ left outer join Product product1_ on product0_.product_id=product1_.id where product0_.affiliate_id=?
Hibernate: select product0_.affiliate_id as affiliate1_1_, product0_.product_id as product2_1_, product1_.id as id0_0_, product1_.price as price0_0_, product1_.capacity as capacity0_0_, product1_.active as active0_0_, product1_.title as title0_0_ from Product_Affiliate product0_ left outer join Product product1_ on product0_.product_id=product1_.id where product0_.affiliate_id=?
Hibernate: select product0_.affiliate_id as affiliate1_1_, product0_.product_id as product2_1_, product1_.id as id0_0_, product1_.price as price0_0_, product1_.capacity as capacity0_0_, product1_.active as active0_0_, product1_.title as title0_0_ from Product_Affiliate product0_ left outer join Product product1_ on product0_.product_id=product1_.id where product0_.affiliate_id=?
Hibernate: select schedule0_.product_id as product3_1_, schedule0_.id as id1_, schedule0_.id as id2_0_, schedule0_.product_id as product3_2_0_, schedule0_.coursedate as coursedate2_0_ from Schedule schedule0_ where schedule0_.product_id=?
Hibernate: select schedule0_.product_id as product3_1_, schedule0_.id as id1_, schedule0_.id as id2_0_, schedule0_.product_id as product3_2_0_, schedule0_.coursedate as coursedate2_0_ from Schedule schedule0_ where schedule0_.product_id=?
Hibernate: select schedule0_.product_id as product3_1_, schedule0_.id as id1_, schedule0_.id as id2_0_, schedule0_.product_id as product3_2_0_, schedule0_.coursedate as coursedate2_0_ from Schedule schedule0_ where schedule0_.product_id=?
Hibernate: select product0_.affiliate_id as affiliate1_1_, product0_.product_id as product2_1_, product1_.id as id0_0_, product1_.price as price0_0_, product1_.capacity as capacity0_0_, product1_.active as active0_0_, product1_.title as title0_0_ from Product_Affiliate product0_ left outer join Product product1_ on product0_.product_id=product1_.id where product0_.affiliate_id=?
Hibernate: select schedule0_.product_id as product3_1_, schedule0_.id as id1_, schedule0_.id as id2_0_, schedule0_.product_id as product3_2_0_, schedule0_.coursedate as coursedate2_0_ from Schedule schedule0_ where schedule0_.product_id=?
Hibernate: select schedule0_.product_id as product3_1_, schedule0_.id as id1_, schedule0_.id as id2_0_, schedule0_.product_id as product3_2_0_, schedule0_.coursedate as coursedate2_0_ from Schedule schedule0_ where schedule0_.product_id=?
Hibernate: select schedule0_.product_id as product3_1_, schedule0_.id as id1_, schedule0_.id as id2_0_, schedule0_.product_id as product3_2_0_, schedule0_.coursedate as coursedate2_0_ from Schedule schedule0_ where schedule0_.product_id=?
Hibernate: select product0_.affiliate_id as affiliate1_1_, product0_.product_id as product2_1_, product1_.id as id0_0_, product1_.price as price0_0_, product1_.capacity as capacity0_0_, product1_.active as active0_0_, product1_.title as title0_0_ from Product_Affiliate product0_ left outer join Product product1_ on product0_.product_id=product1_.id where product0_.affiliate_id=?