Joined: 30 Oct 2008
Location: United States
Online Status: Offline
Posts: 44
Topic: Joining mirrored tables Posted: 30 Oct 2008 at 9:39am
I am trying to run a report that will pull data from two tables. One is open orders and the other is closed. We now create two different reports. Any ideas on how to accomplish this? I appreciate any ideas.
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Posted: 31 Oct 2008 at 1:54am
Hi,
You can Join the Tables in Primary Keys which could be Order ID'S in both the tables,and then you may have some status field which tells you when the Order is Closed Or Opened
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
