query in three tables (1 reply)
(MySQL.com) got three tables as follows
user_master,user_actions_type,user_actions
How to make a view involving three tables.
user_master
userid (int primary), user_name (varchar)
1, James
2, Alex
3, Justin
user_actions_type
act
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-01 21:50:10
