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 >
