select count(distinct(b.ActionItemId)) as Total_Records from ActionItem b
LEFT JOIN actionstmts d ON b.actionitemid =d.actionitemid,ActionItem b LEFT
JOIN ActionCaseType c ON c.actionitemid=b.actionitemid where
Upper(actionname) like Upper('%')

error:-- A reference to column "B.ACTIONITEMID" is ambiguous.

Kindly suggest the solution

Regards

Amit Singal




DB2 & UDB email list listserv db2-l LazyDBA home page