Hi I know this should be easy but I just can't seem to figure it out. This Insert statement works fine but if the row already exists you get a bunch of errors that you have to skip through. There is a PK on those 3 columns.
How would I add when the row does not Exist? INSERT + INTO aptbook (aptdate,apttime,ampm) + SELECT t1.aptdate,t2.apttime,t2.ampm + FROM aptdate t1, apttime t2 + WHERE aptdate BETWEEN .vsdate AND .vedate + ORDER BY aptdate,apttime Thanks Marc
