Search results for query: *

I have tried something like this: select * from micros.trans_dtl INNER JOIN micros.dtl on micros.trans_dtl.trans_seq = micros.dtl.trans_seq INNER JOIN micros.mi_dtl on micros.dtl.trans_seq = micros.mi_dtl.trans_seq and micros.dtl.dtl_seq = micros.mi_dtl.dtl_seq INNER JOIN micros.mi_def on...

I am exporting rpt_ttl. But it is more than just the total that isn't adding up. I am having problems where certain menu items show that they were sold x times in the built in report and I only see them y times in micros.dtl joined to micros.mi_dtl on mi_seq. In this case y is usually less...

I am trying to run it for the previous day. I guess the best explanation for what I am trying to do is export all of the Menu Item transaction data. This way I can pull it into another database and statistically analyze it. I have been able to do this already to some effect; however, when...

Ok, so how do I run these reports if they are unadvertised? I was doing the joins as you described(I actually based this off of a previous post that you replied to that was quite helpful: http://www.tek-tips.com/viewthread.cfm?qid=1164015&page=1), but I was also doing joins on...

I am having a heck of time trying to get data in the micros.dtl to match up with data from the reports. I have yet to get things to come out correctly. I have tried these three tables micros.dtl, micros.vta_basedtl, micros.v_dtl. Nothing seems to match the reports from the...