Hello,
I have to queries that I use:
string query = "SELECT SiteListId.* FROM SiteListId LEFT JOIN SiteReport ON(SiteListId.Site = SiteReport.Site) WHERE SiteReport.Site IS NULL";
the one above compering between 2 tables, SiteListId and SiteReport and the output is the differences.
var query = "SELECT Site FROM SiteReport WHERE Date <= '"+dt+"' AND Date >= '"+NewDate+"'";
the above is pulling values from table SiteReport between 2 dates.
my question is:
is there a way to combine the queries?
i need to pull the info from SitePort between the dates and compare it with ListId for difference.
thank you,
Shay.