Glad I could help. I use the DISTICT syntaxt to optimize the query. Dennis McGrath
--- Jim Limburg <[EMAIL PROTECTED]> wrote: > Dennis > > 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 > >> > > > > > > >
