זו השאלתה - מאוד פשוטה
וגם רצה ב query analyzer ברגע... SELECT Payments.PAYM_CLAIM, Payments.PAYM_PORS, Responsibles_For_Cases.RESP_CASE_CLAIM, Responsibles_For_Cases.RESP_CASE_RESP, Responsibles.RESP_NAME, Injures.INJR_PRE_ID, Injures.INJR_ID, CONVERT (varchar(1), Injures.INJR_ID_CHECK) AS INJR_ID_CHECK, Injures.INJR_LNAME, Injures.INJR_FNAME, Cases.CASE_DATE FROM Responsibles_For_Cases LEFT OUTER JOIN Accounts ON Accounts.ACNT_CASE = Responsibles_For_Cases.RESP_CASE_CASE AND Accounts.ACNT_RESP = Responsibles_For_Cases.RESP_CASE_RESP AND Accounts.ACNT_DATE >= Responsibles_For_Cases.RESP_CASE_FROM_DATE AND (Responsibles_For_Cases.RESP_CASE_TO_DATE IS NULL OR Accounts.ACNT_DATE <= Responsibles_For_Cases.RESP_CASE_TO_DATE) LEFT OUTER JOIN Cases ON Accounts.ACNT_CASE = Cases.CASE_NUM LEFT OUTER JOIN Payments ON Payments.PAYM_CODE = Accounts.ACNT_NUM AND Payments.PAYM_ATTR = 1 LEFT OUTER JOIN Injures ON Injures.INJR_NUM = Cases.CASE_INJR LEFT OUTER JOIN Responsibles ON Accounts.ACNT_RESP = Responsibles.RESP_NUM where paym_num in(1661677,1661722) and payments.paym_upddate>=convert(smalldatetime,' 25/08/2005 00:00:00',103) and ('25/08/2005 23:00:00' is null or payments.paym_upddate<=convert(smalldatetime,'25/08/2005 23:00:00 ',103)) and paym_claim is not null
