cancel
Showing results for 
Search instead for 
Did you mean: 

Recursive column %1: conversion from '%2' to '%3' loses precision Error:-945

ximen
Participant
0 Kudos
2,022
 WITH RECURSIVE PS ( product_code,description,parent_id,customer_id,short_name,quantity) as
      (select product_code,description,parent_id,'ID' D,'Sname' E,F=1*1  from product_code where parent_id='CP'
     union all
      select b.product_code,b.description,b.parent_id,cu.customer_id,cu.short_name,shl.quantity  from 
     ((((ps p join product_code b on p.product_code=b.parent_id ) 
        join part s on b.product_code=s.product_code) join shipper_line shl on s.part_id=shl.part_id) 
        join shipper sh on shl.trans_no=sh.trans_no) join customer cu on sh.customer_id=cu.customer_id)
 select * from ps

Accepted Solutions (0)

Answers (0)