I can't get join into my new table TMP
I can get this join to work
SELECT L.LICENSEID, L.LICENSEE, S.STATIONID,S.STATION,S.CALLS,
S.AMFM,S.FILL,S.CITY,S.COUNTY,S.STATE,S.ONAIRSTATS,S.CPB,S.NPR,
S.PRI,S.RLG,S.METROHOME,S.DMAHOME,S.TALLY,S.SEESTA,S.SEESTATYPE,
S.SEESTAID,S.FREQ,S.LICENSEE,S.OLDCALLS,S.CLCDATE,S.TZWI,S.TZSP,
S.TZSU,S.TZFA,S.BUSINESSNM FROM LICENSE AS L INNER JOIN STATIONS AS S
ON L.LICENSEE = S.LICENSEE;
However, I created a table called tmp and when I try to insert the join into this table I get an error message that says I have duplicate values. Only 34 records are displayed in the tmp table and the licensee column in the tmp table have the wrong values. Is there a way to create a table without defining datatypes and just copy the above join into a new table?
Lorin Kaneff
Production Assistant
Radio Research Consortium
www.rrconline.org