03-13-2015 11:22 AM
I have dataset abc with 4 variables ID,VISITNAME,VISITNUM,VISITDATE with ID being the primary key....this dataset and will have information only relating to all possible
visits for that id.This dataset is dynamic and dataset will keep updating as and when new visits take place which is expected to continue for over a period of time(2 years)....visitnum could be 1,2,3,4,5,6,to n......
There are other datasets like x,y,z which will have other information and also VISITNAME,VISITNUM,VISITDATE as supporting variables to complement the data...
i would like write a query in such a way that VISITNUM,VISITDATE in abc dataset should match the corresponding VISITNUM,VISITDATE in other datasets x,y,z....if they are not matching then it is a discrepancy and we should
output those discrepancies for those individual datasets....
03-13-2015 11:36 AM
If you are looking for vistnum the same with a different date something like:
select a.*, b.visitdate as differentvisitdate
from abc as a left joint x as b
on a.visitname=b.visitname and a.visitnum= b.visitnum
where a.visitdate ne b.visitdate;
might be start. I include the ID and name so you know where to look.