Home Forums Article Discussions Article Discussions by Author Discuss content posted by Kev Riley UNION error RE: UNION error

  • November 6, 2008 at 8:14 am

    #894916

    I agree with "J"!

    Although I had selected "change the data type to varchar(max)" I removed it as the scenario had stated that no duplicates could be assumed. Therefore, the only proper solution (workaround) to the problem stated was to use UNION ALL -- which, by the way should have used in the first place if the data is not duplicated between the two tables.

    A data type change to a table is NOT a "workaround".

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]