Skip to Content
0
Former Member
Jun 08, 2009 at 04:05 PM

Query problem please help

24 Views

Hi,

i' ve a problem with a query: i want to see only serial number with a Credit notes but i'm not able to complete them: this is the query

SELECT T0.[ItemCode], T0.[ItemName], T1.[IntrSerial] FROM SRI1 T0 INNER JOIN OSRI T1 ON T0.SysSerial = T1.SysSerial WHERE T0.[BaseType] = 14 and T1.[Status] = '0'

Help me thanks.

regards