Need to return Data Across DataSet Tables...

  • Thread starter Thread starter James Pose
  • Start date Start date
J

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?
 
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
 
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.
 
Back
Top