Returning the query result of three UNION tables to VIEW

[eluser]@rno[/eluser]
Hi,

I think you should slightly change your SQL, make ik look like:

Code:

SELECT productid AS 'id', name, description, 1 AS 'tble_type' FROM product
UNION
SELECT serviceid AS 'id', name, description, 2 AS 'tble_type' FROM services
UNION
SELECT imageid AS 'id', name, description, 3 AS 'tble_type' FROM image

This way you get 4 columns, all having the same name, so displaying them all at once, or separated bij 'tbl_type' wouldn't be any problem.

Regards,
Arno