General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
The query that you provided only get the records that have an RD record for a particular date and no matching RI record. I also need the RI records that match but the transaction date is greater than particular date.
I have a table that records transations.
When a part comes to our dock an RD(received to dock) transaction and date is recorded. When the part gets inspected an RI(received to inspection) transaction and date is recorded.
So I need the number of parts that were in inspection on last Monday.
I need all the parts that have an RD transaction record on or before the Monday date and that either has never been RI transaction or the RI transation date was after Monday date..
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only