Interacting with Databases through the Java Persistence API - Java EE 6 Development with NetBeans 7 - page 218

The table to hold orders was named CUSTOMER_ORDER since the word
"ORDER" is a reserved word in SQL.
Let's take a look at the CustomerOrder JPA entity to see how the many-to-many
relationship is defined:
package com.ensode.jpa;
//imports deleted for brevity
@Entity
@Table(name = "CUSTOMER_ORDER")
@NamedQueries({
@NamedQuery(name = "CustomerOrder.findAll",
query = "SELECT c FROM CustomerOrder c"),
@NamedQuery(name = "CustomerOrder.findByCustomerOrderId",
query = "SELECT c FROM CustomerOrder c WHERE "
+ "c.customerOrderId = :customerOrderId"),
@NamedQuery(name = "CustomerOrder.findByOrderNumber",
query = "SELECT c FROM CustomerOrder c WHERE "
+ "c.orderNumber = :orderNumber"),
@NamedQuery(name = "CustomerOrder.findByOrderDescription",
query = "SELECT c FROM CustomerOrder c WHERE "
+ "c.orderDescription = :orderDescription")}) public
class CustomerOrder implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@Basic(optional = false)
@NotNull
@Column(name = "CUSTOMER_ORDER_ID")
private Integer customerOrderId;
@Size(max = 10)
@Column(name = "ORDER_NUMBER")
private String orderNumber;
@Size(max = 200)
@Column(name = "ORDER_DESCRIPTION")
private String orderDescription;
@JoinTable(name = "ORDER_ITEM", joinColumns = {
@JoinColumn(name = "CUSTOMER_ORDER_ID",
referencedColumnName = "CUSTOMER_ORDER_ID")},
inverseJoinColumns = {
@JoinColumn(name = "ITEM_ID",
referencedColumnName = "ITEM_ID")})
@ManyToMany