{"action":"created","issue":{"url":"https://api.github.com/repos/JumpMind/metl/issues/387","repository_url":"https://api.github.com/repos/JumpMind/metl","labels_url":"https://api.github.com/repos/JumpMind/metl/issues/387/labels{/name}","comments_url":"https://api.github.com/repos/JumpMind/metl/issues/387/comments","events_url":"https://api.github.com/repos/JumpMind/metl/issues/387/events","html_url":"https://github.com/JumpMind/metl/issues/387","id":167767666,"number":387,"title":"Hint with alias name","user":{"login":"spyhunter88","id":4862357,"avatar_url":"https://avatars.githubusercontent.com/u/4862357?v=3","gravatar_id":"","url":"https://api.github.com/users/spyhunter88","html_url":"https://github.com/spyhunter88","followers_url":"https://api.github.com/users/spyhunter88/followers","following_url":"https://api.github.com/users/spyhunter88/following{/other_user}","gists_url":"https://api.github.com/users/spyhunter88/gists{/gist_id}","starred_url":"https://api.github.com/users/spyhunter88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spyhunter88/subscriptions","organizations_url":"https://api.github.com/users/spyhunter88/orgs","repos_url":"https://api.github.com/users/spyhunter88/repos","events_url":"https://api.github.com/users/spyhunter88/events{/privacy}","received_events_url":"https://api.github.com/users/spyhunter88/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-27T04:27:42Z","updated_at":"2016-07-27T09:38:57Z","closed_at":null,"body":"Hi,\r\n\r\nI have selected more than 20 columns in 4 tables with the same name. But they output to 4 Output Model. I want they output in the same Output Model.\r\nWith the hint function, I need to write 20 lines of code in 3 (keep first table) tables. Why I can't use alias name in SQL? The following code is in mysql, other database maybe difference.\r\n`select col1, col2.... from my_table_data_2 as my_table_data_1;`"},"comment":{"url":"https://api.github.com/repos/JumpMind/metl/issues/comments/235537151","html_url":"https://github.com/JumpMind/metl/issues/387#issuecomment-235537151","issue_url":"https://api.github.com/repos/JumpMind/metl/issues/387","id":235537151,"user":{"login":"nrichardson99","id":14093056,"avatar_url":"https://avatars.githubusercontent.com/u/14093056?v=3","gravatar_id":"","url":"https://api.github.com/users/nrichardson99","html_url":"https://github.com/nrichardson99","followers_url":"https://api.github.com/users/nrichardson99/followers","following_url":"https://api.github.com/users/nrichardson99/following{/other_user}","gists_url":"https://api.github.com/users/nrichardson99/gists{/gist_id}","starred_url":"https://api.github.com/users/nrichardson99/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nrichardson99/subscriptions","organizations_url":"https://api.github.com/users/nrichardson99/orgs","repos_url":"https://api.github.com/users/nrichardson99/repos","events_url":"https://api.github.com/users/nrichardson99/events{/privacy}","received_events_url":"https://api.github.com/users/nrichardson99/received_events","type":"User","site_admin":false},"created_at":"2016-07-27T09:38:57Z","updated_at":"2016-07-27T09:38:57Z","body":"You use hints on the column references themselves if you need the component to map to a different output model.  It won't pick up table aliases when mapping the output.\r\n\r\nselect col1 /* my_table_data_1.col1 */ \r\n     , col2 /* my_table_data_1.col2 */\r\n     , col3 /* my_table_data_1.col3 */\r\n     .... \r\nfrom my_table_data_2 ;\r\n\r\nFor another example see example 2 at https://github.com/JumpMind/metl/wiki/rdbms-reader"}}
{"actor":{"display_login":"nrichardson99"}}