relative newbie here. Only got serious with SQL within the last month or so for work, so I'm still pretty rusty with it.
Is it posible for a query to pull results after a date, but also ones of the same ID that fall before the date?
Sorry for the title gore, but I'm not sure if there's a better way to word it.
I'm trying to run a query that would normally return results from a table that looks like this:
And if I were to want it to return all lines after 10/1/16, It would pull lines 1, 6, 7, 8, 9, 10, but what I want it to do is to pull everything for that ID, if just one of the lines was past a certain date.
The results should more or less look like this:
...if I were to enter a date of greater than 10/1/16.
Is that possible to do within SQL? For the record, I'm on SQLdbx.
Thanks a ton!