can I combine SELECT statements for columns located in different table into one view?
Somthin like this: SELECT
'company',
'phone',
'e-mail',
FROM 'companies' SELECT
'country',
FROM 'adresses' the result should be a query with _|company|phone|e-mail|country|_combined in one view. I've tried around with no prositive result - any tips, tricks and hints? thanks in advance
As an alternative, you can use MYSQL Query Browser to create queries and views, this can be downloaded from MYSQL.com
I use the free version of Navicat, from the pcplus cover disc of about a year ago for all my mysql management, the latest version allows the creation of views too.
Both of the above are just drag and drop editors, then you can cut and paste the query to phpRunner. HTH