I have two inventory transaction tables. One is a history table, and the other is a current table. What would the SQL look like so that I can get the results from both tables for a specific item number?
Thanks.