THAT'S IT... said Charlie Brown...
I never remember the IN syntax... I didn't know the NOT IN was a choice although it seems like common sense. I definitley am going to do a restudy on basic and maybe advanced SQL soon. One we get all this WAN/VPN system and Novell Groupwise talking between companies that is..
Thanks Dennis Jim Limburg
Dennis McGrath wrote:
Jim,
SELECT * FROM MPO WHERE Mponum not in (SELECT DISTINCT Mponum FROM TimeTracking)
Dennis McGrath
--- Jim Limburg <[EMAIL PROTECTED]> wrote:
G-Day all
I would like some advice.
We have one table which is basically a header table for MPO to track jobs in the plant.. then another table that gets data from timeclocks for each Mpo number and related data..
I want a view and ultimatley a report that I would run on this view to show all the mpos that do not have time put onto them. In other words Mpos entered into the system, but not yet started on..
General info in the header table I would like to collect would be Mponum, Itemnum, ShrtDesc,QtyOrd,Location,shopordr
and then the table of time tracking we have Mponum,WrkDate,WorkHrs,OTHrs,DTHrs,ClockNo
Can someone give some suggestions to break this fog I'm in..
I know this is so simple it's going to make me kick my can when I see it, but I've had one of those head in the cloud days..
Thanks for input Jim Limburg
