1 Reply Latest reply on Oct 26, 2006 7:41 AM by paross1

    query/right join/

    Coldfusionstudent Level 1
      query/right join/

      Ultimately we are trying to find the ZZOMTAB.STAFF
      I know the value exist because I have queried this by
      K_NO
      By this query

      Select
      ZZOMTAB.STAFF
      from
      ZZOMTAB
      where
      K_NO = 146735

      so it is there
      but what I am supplied with is app_no=79219

      I have tried this query and it does not work ( no value in the ZZOMTAB.STAFF)
      SELECT
      ZZOMTAB.STAFF
      FROM TKASERTAB
      RIGHT JOIN ZZOMTAB
      ON TKASERTAB.K_NO = ZZOMTAB.K_NO

      RIGHT JOIN APPTAB
      ON TKASERTAB.app_no= APPTAB.app_no

      where
      APPTAB.app_no=79219


      the value that I am trying to get is in ZZOMTAB.STAFF
      and I am given with app_no=79219

      the tables are

      tables are
      TKASERTAB with columns K_NO and APPNO
      APPTAB with column APPNO
      and
      ZZOMTAB with K_NO

      I am trying to get the value of ZZOMTAB.STAFF
      Can someone help??
      Thanks in adv