I have created 2 tables (users and actions), inserted 3 and 5 records in them and created a view using:
CREATE VIEW actions_users as SELECT actions.action_id AS action_id, actions.user_id AS user_id, actions.page_id AS page_id, actions.action_type_id AS action_type_id, actions.action_when AS action_when, users.user_name AS username, users.user_nickname AS nickname FROM actions LEFT JOIN users ON actions.user_id = users.user_id ORDER BY actions.action_when ASC
I have exported everything to sql format and I have attached the files. The values for actions_users.sql are incorrect and will fail if all the files are imported into another database.
Also, the sql export creates for some reason the table actions_users also.