hi,
am retriving data from two tables(RDR1,@DOCUMNET) by making joins
when i am giving conditions in where clause of @DOCUMENT am got the below error
BUT without any conditons in where clause all data is retriving from tables
"This entry already exists in the following tables 'Service Contracts' (OCTR) (ODBC -2035) [Message 131-183]"
example:
" select * FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry LEFT JOIN [dbo].[@DOCUMENT] T2 ON T1.DocEntry=T2.U_DocEntry AND
T1.LineNum=T2.U_LineNum
WHERE T0.[DocNum]=[%0]
AND T1.[Dscription]='[%1]'"