Re: SQL Select Question

[Heather Shuler <hcshuler@SUMMON3.SYR.EDU>]

You could call a procedure from within your main select.  Then in the
called procedure look at table B (through a select) to see if it
contains the value from table A.  If it does set a flag.  Back in the
main select check the flag's value.  If it is acceptable print or write
the values.  Outline:
BEGIN PROCEDURE
BEGIN - SELECT
COL1
COL2
COL3
        DO CHECKB
        IF $VALUEEXISTS = 'FALSE'
                PRINT COL1 ()
                PRINT COL2 ()
                PRINT COL3 ()...
        END-IF
FROM TABLE_A
END - SELECT
END PROCEDURE
*****************
BEGIN PROCEDURE CHECKB
MOVE 'FALSE' TO $VALUEEXISTS
BEGIN - SELECT
COL1
        MOVE 'TRUE' TO $VALUEEXISTS
FROM TABLE_B
WHERE COL1 = &TABLE_A.COL1




C. Duncan Hudson wrote:
>
> I realize that this is really an SQL question, and not an SQR question
> but I was hoping that with everyone's expertise here I could get a
> quick (and satisfactory) answer.
>
> Here's my question.  I want to create a report that selects about 10
> columns from a single table.  The selection should be based upon field
> values within that table.  Also (and here's where I'm having
> problems), I need to look at another table to see if the first table's
> primary key is represented in it.  If it is, I want to exclude it from
> my selection.  Do you follow that?  Here's a crude visual:
>
> TABLE A                 TABLE B
> 100                     98
> 101                     100
> 105                     108
> 107                     110
> 110
> 111
>
> In the above example I would want to select 101, 105, 107 and 111 from
> Table A.  Can anyone give me a hand?  Thanks in advance,
>
> Dunc.
>
> _________________________________________________________
> DO YOU YAHOO!?
> Get your free @yahoo.com address at http://mail.yahoo.com

--
Heather C. Shuler
Computer Consultant
Human Resources Department
Syracuse University
(315) 443-3941
hcshuler@syr.edu