Assuming I have a sql statement that joins two tables Table A1 & Table B2
Table A1
ID DATETIME
A 4/6/2010 7:17:09
B 4/6/2010 7:16:09
C 4/6/2010 7:15:09
Table B2
ID REF
A
B 12
C 13
Joined A1 & B2
ID DATETIME REF
A 4/6/2010 7:17:09
B 4/6/2010 7:16:09 12
C 4/6/2010 7:15:09 13
I would like an alert that A does not have a REF value.
Any thoughts? Feel free to change up anything to make it work!
-Michael
