I have a table reflecting now, and the same table from x days ago.
I query both but only want the differences in a particular column D to display, not both tables. Just the parts of the tables based on the change in column D. I have the queries linked together and the design view is something like
bla bla bla fields etc. w/
And it does display the changed value in column D plus all other associated data. However, it also feeds in the past data on the row below it.
Like, customer X has date change in column D and in the row below it the same customer X shows previous date in column D. Nice for comparison but...
How can I exclude the previous data and only display the current change?
I am trying joining two tables using a common ID and only returning data from a difference in a common column.
FROM t2 LEFT JOIN t1 ON t1.someID = t2.someID
WHERE t1.someID IS NULL
but I got too many results.
my original, which I had help from our resident expert, looks more like
FROM t2 Inner JOIN t1 ON t1.someID = t2.someID
WHERE t1.someID <> t2.someID
but it results in something like
Frank Last week
whereas I don't need to know frank ordered last week, just today. um I guess what I'm trying to say is, the queries do join but they return *both* of the differences that I am extracting from them. And I'd rather have just the recent difference returned only.
Is it the Join part that I'm not structuring properly?