Need to return Data Across DataSet Tables...

[James Pose]

.... not sure what the best way to do this. What i need to do is return
all the records in 1 table that don't exist in another table.

scenio
Table A contains a list of Tasks to work on.
Table B contains a list of Tasks that are currently being worked on.

So what I need returned is a list of all Tasks not being worked on.

SELECT *
FROM A
WHERE (NOT (A_ID IN
(SELECT A_ID
FROM B)))

I don't believe I can do a select across tables in a dataset.


Ideas?

 

[Guest]

James,

You should be able to use a subquery. For example:

Select * From A Where A_ID Not In (Select A_ID From B)

You will need to get the syntax right for the particular DBMS you are using.

Kerry Moorman

 

[James Pose]

I think i was not clear on my question.
I know i can use Select * From A Where A_ID Not In (Select A_ID From B)
against a DBMS what I was wondering is how to it against a Dataset where
Table A is filled from a DBMS and Table B is updated from the application
as the tasks in Table A are being worked on.

I hope that is clearer.