I have a two tables `oc_order` and `oc_customer`. I want to get customers who order more than once.

This is sample:

**oc_order:**

    order_id | cus_id | cus_name
    -------------------------------
    1        | 1      | Kumar
    2        | 2      | Vimal
    3        | 1      | Kumar
    4        | 3      | Ramesh

**oc_customer**
  

      cus_id   | cus_name |  cus_address
        -----------------------------------
        1        | Kumar    |  Chennai
        2        | Vimal    |  Coimbatore
        3        | Ramesh   |  Selam
        4        | Deepan   |  Chennai
        5        | Ashok    |  Coimbatore


>For the above example i want to select only repeated order customer details only.

I mean now select only `cus_id`- 1 details, because customer one order more then one time.

This is the query am used

    SELECT * 
    FROM oc_order o 
    LEFT JOIN oc_customer oc ON (o.customer_id = oc.customer_id) 
    WHERE  (SELECT * 
            FROM oc_order 
            WHERE customer_id=o.customer_id)