Neculai Macarie wrote: [] > select 'gallery' as table_name, d_image_small, d_image_big > from gallery > UNION > select 'gallery_categ' as table_name, d_image, NULL > from gallery_categ > order by table_name; [] > select 'gallery' as table_name, d_image_small, d_image_big > from gallery > union > select 'categ' as table_name, d_image, NULL > from gallery_categ > order by table_name; Making a twist to the samples provided select 'categ' as table_name, d_image, '.' as big from gallery_categ union select 'gallery' as table_name, d_image_small , d_image_big from gallery order by table_name; the results are amazing 'table_name','d_image','big' 'categ','img22.jpg','.' 'categ','img23.jpg','.' 'categ','img21.jpg','.' 'galle','img3.jpg','i' 'galle','img6.jpg','i' 'galle','img1.jpg','i'
To my observations constants in a column declaration limit the column width to just fit the initial constant. Your choice of values 'gallary' and 'gallery-categ' just masked that out ;-) A workaround can be found in creating an additional table -never to hold data- create table dummy ( _name char(25), _small char(100), _big char(100)); and selecting it upfront of the unions to the filled tables select * from dummy union select 'categ' , d_image, null from gallery_categ union select 'gallery' , d_image_small , d_image_big from gallery order by _name; BTW I use this kind of a dummy table just to easy (re)name collumns in a union-ed resultset: not a simngle 'as' in any select. HansH -- Running 4.1.0-alpha-max-nt On WindowsXP -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]