The form that I am working on has a key block Swamajr_Key_Block followed by the first database block, Swbmajr further down the list. When I enter all the values into the text items in the key block and press Page Down, then control will move to the Swbmajr block. The Swbmajr block is tied to the table Swbmajr. In the WHERE clause property of this data block, I wish to write the following code:


SELECT A.SWBMAJR_SBGI_CODE, A.SWBMAJR_MAJR_CODE, A.SWBMAJR_CONC_CODE,
    A.SWBMAJR_DEGT_TRNS, A.SWBMAJR_DEGC_INST, A.SWBMAJR_YEAR_CODE
    FROM SWBMAJR A
    WHERE A.SWBMAJR_SBGI_CODE = :Swamajr_Key_Block.Inst_Code
    AND Swbmajr_degt_trns = :Swamajr_Key_Block.Degt_Trns_Code
    AND Swbmajr_degc_inst = :Swamajr_key_block.degc_inst_code
    AND Swbmajr_majr_code = :Swamajr_key_block.majr_code
    AND Swbmajr_conc_code = :Swamajr_key_block.conc_code
    AND Swbmajr_acyr_code =
                      (SELECT MAX (B.swbmajr_acyr_code)
                            FROM swbmajr B
                            WHERE B.SWBMAJR_ACYR_CODE <= :Swamajr_key_block.term_code_eff
                            AND B.SWBMAJR_SBGI_CODE = A.SWBMAJR_SBGI_CODE
                        AND B.SWBMAJR_DEGT_TRNS = A.SWBMAJR_DEGT_TRNS
                        AND B.SWBMAJR_DEGC_INST = A.SWBMAJR_DEGC_INST
                        AND B.SWBMAJR_MAJR_CODE = A.SWBMAJR_MAJR_CODE
                        AND B.SWBMAJR_CONC_CODE = A.SWBMAJR_CONC_CODE);

My question is how can I put the alias A in the FROM statement when the properties for the data block starts with the WHERE Clause? What I mean is that there is no FROM clause for me to put SWBMAJR A. Or  could I just use the keyblock values in there too, i.e. AND B.SWBMAJR_SBGI_CODE = :Swamajr_Key_Block.Inst_Code
                        AND B.SWBMAJR_DEGT_TRNS = :Swamajr_Key_Block.Inst_Code, etc.