Database

select a.productname, 
case when b.agentid is null then 'False' else 'True' end AS status
from products a 
left outer join agent b on a.productid = b.productid 
and b.agentid ='1001'

prog_mafia wrote:

i need guidelines

SELECT ROWNUM as NR_OF_DAYS, DAY AS MAX_CALENDAR_DAY
     FROM (SELECT DAY
           FROM CALENDAR
           WHERE DAY > TRUNC(TO_NUMBER(SYSDATE - TO_DATE('01.01.1970', 'DD.MM.YYYY')))
           AND CALENDAR.IS_WORKING_DAY= 'y'
           ORDER BY CALENDAR.DAY
          )
     WHERE ROWNUM <= (SELECT MAX(NR_OF_DAYS) FROM WORKCENTER WHERE WORKCENTER.ID IN ( 1, 2, 6, 7, 9))

SELECT ID,
       DAY
FROM (SELECT ROWNUM as CAL_ROWNUM, 
             DAY AS MAX_CALENDAR_DAY     
             FROM (SELECT DAY 
                   FROM CALENDAR
                   WHERE DAY > TRUNC(TO_NUMBER(SYSDATE - TO_DATE('01.01.1970', 'DD.MM.YYYY')))
                   AND CALENDAR.IS_WORKING_DAY= 'y'
                   ORDER BY CALENDAR.DAY)
             WHERE ROWNUM <= (SELECT MAX(NR_OF_DAYS)
                              FROM WORKCENTER
                              WHERE ID IN (1, 2, 6, 7, 9))
     )
INNER JOIN WORKCENTER
ON NR_OF_DAYS = CAL_ROWNUM
WHERE ID IN (1, 2, 6, 7, 9)