Re: Join with absent values in right table

2002-02-28 Thread DL Neil
Hi Tim, > Assume I have two tables, A and B, and both share a key field (for the > sake of argument, lets call it key_id). Is there a way to determine for > which values of key_id in A there is no corresponding row in B? > e.g I might have Table A: > key_id , value > 1,1 > 2,1 > 3,3 > 4,4 > > an

Join with absent values in right table

2002-02-27 Thread Tim Wood
Hi Assume I have two tables, A and B, and both share a key field (for the sake of argument, lets call it key_id). Is there a way to determine for which values of key_id in A there is no corresponding row in B? e.g I might have Table A: key_id , value 1,1 2,1 3,3 4,4 and Table B key_id, other