```
SELECT b.*,
       a.jeopCodeId,
       a.JeopCodeDetail
FROM   storm_jeopinfo     a,
       storm_orders       b
WHERE  a.ordernumber IS NOT NULL
       AND a.ordernumber = b.order_number
       AND b.Installed_dt IS NOT NULL
       AND b.CUST_SIGN_DT BETWEEN CONVERT(date, '2012-06-01', 102) 
                              AND CONVERT(date, '2013-04-30', 102)
    UNION ALL
SELECT b.*,
       a.jeop_code,
       a.jeop_desc
FROM   storm_bpm_jeops     a,
       storm_orders        b
WHERE  b.order_number = a.Order_number
       AND b.srvc_order_unit = a.srvc_order_unit

```

> 
> Error msg: Conversion failed when converting the varchar value
>  'JEOP-008' to data type int.
> 
> 
> 

It continues in the series with the next columns. Am unable to successfully execute this query.