Every now and then I see a web site that has an old copyright date.
In my mind, I always think "Look at the sucker who forgot to update his copyright year!
This includes selling a book or leaving free copies of it in a public place or posting content on your blog.
Publication does not include, for example, circulating copies internally to co-workers.
Occasionally this comes up as a point of complaint on librarians' (especially catalogers') email discussion lists, but the prevailing attitude is that in 5-10 years a fudge factor of 6 months to a year won't matter in the scheme of literary output.A copyright date is used in cataloging only when no publication date is on the book.Publishers have been post-dating publication dates and copyright dates for as long as they've been putting them in books.Today in common parlance, even among some librarians, the terms publication date and copyright date may be used interchangeably. Material may have been completed and copyrighted in one year, but not published until the next for any number of reasons including seasonal sales strategies, printing delays, you name it.If there's a significant discrepancy between publication date and copyright date, it's noted in the cataloging.The query would in fact execute without any error messages since the correlated subquery in SET clause returns EXACTLY one row for each row in B and the where clause executes without error. Lets say you have a table A ( id int, a1 varchar2(25) ) and a table B ( id int PRIMARY KEY, b1 varchar2(25) ). REGISTRATION(BIN, NAME, NAME_ALIAS, COR_GROUP, AUTHOBY, AUTHODATE, CG_NAME, ADD1, ADD2, ADD3, TEL1, FAX1, ADD5, ADD6, ADD7, TEL2, FAX2, ADD9, ADD10, ADD11, TEL3, FAX3, TP_TYPE, TRD_LINC, TRD_FY, TRD_AUTH, IMP_REG, EXP_REG, REG_TYPE, TIN, STATUS, PRE_BIN, DATREG, STAT_CHNG, ACT_CODE, ACT_MULT, ITEM_TYPE, OLD_ACT, APP_CAT, LCODE, ISSUE_DATE, VREG, M_POSI, MFUNC, SFUNC, LAST_USER, LAST_ACCS, TREG, PAY_FREQ, CREG, EREG, OREG, OP_BAL, OP_BAL_DT) select BIN, NAME---- from VIS. Thank u very much for ur kind & very helpful reply. Here the source tables have data with leading spaces and the target data should be without spaces.