{"action":"created","issue":{"url":"https://api.github.com/repos/dinedal/textql/issues/20","labels_url":"https://api.github.com/repos/dinedal/textql/issues/20/labels{/name}","comments_url":"https://api.github.com/repos/dinedal/textql/issues/20/comments","events_url":"https://api.github.com/repos/dinedal/textql/issues/20/events","html_url":"https://github.com/dinedal/textql/issues/20","id":27241325,"number":20,"title":"Joins over two files","user":{"login":"tlehman","id":261552,"avatar_url":"https://avatars.githubusercontent.com/u/261552?v=3","gravatar_id":"","url":"https://api.github.com/users/tlehman","html_url":"https://github.com/tlehman","followers_url":"https://api.github.com/users/tlehman/followers","following_url":"https://api.github.com/users/tlehman/following{/other_user}","gists_url":"https://api.github.com/users/tlehman/gists{/gist_id}","starred_url":"https://api.github.com/users/tlehman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tlehman/subscriptions","organizations_url":"https://api.github.com/users/tlehman/orgs","repos_url":"https://api.github.com/users/tlehman/repos","events_url":"https://api.github.com/users/tlehman/events{/privacy}","received_events_url":"https://api.github.com/users/tlehman/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2014-02-10T04:30:50Z","updated_at":"2015-12-16T17:18:08Z","closed_at":"2015-12-16T17:18:08Z","body":"First of all, textql is awesome!\r\n\r\nI haven't been able to figure out how to do a JOIN in a single command (if that's even possible), as a concrete example I have two TSV files, one for child mortality by country and another for GDP by country:\r\n\r\n```\r\n→ ls\r\nmort.tsv  gdp.tsv\r\n```\r\n\r\nI can do queries over each file, sorting, selecting, limiting, etc.\r\n\r\n```\r\n→ textql -dlm=tab -header=false -source=gdp.tsv -sql='select c1, c0 from tbl order by cast(replace(c1,\",\",\"\") as integer) desc LIMIT 5'\r\n16,244,600,000,000, United States\r\n8,227,102,629,831, China\r\n5,959,718,262,199, Japan\r\n3,428,130,624,839, Germany\r\n2,612,878,387,760, France\r\n```\r\n\r\nWhat I would like to do is an inner join on the two files on the country column.\r\n\r\nFrom looking at the source code, I see that there is one `table_name` variable, does this mean that only one table is supported?\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/dinedal/textql/issues/comments/165181790","html_url":"https://github.com/dinedal/textql/issues/20#issuecomment-165181790","issue_url":"https://api.github.com/repos/dinedal/textql/issues/20","id":165181790,"user":{"login":"dinedal","id":606028,"avatar_url":"https://avatars.githubusercontent.com/u/606028?v=3","gravatar_id":"","url":"https://api.github.com/users/dinedal","html_url":"https://github.com/dinedal","followers_url":"https://api.github.com/users/dinedal/followers","following_url":"https://api.github.com/users/dinedal/following{/other_user}","gists_url":"https://api.github.com/users/dinedal/gists{/gist_id}","starred_url":"https://api.github.com/users/dinedal/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dinedal/subscriptions","organizations_url":"https://api.github.com/users/dinedal/orgs","repos_url":"https://api.github.com/users/dinedal/repos","events_url":"https://api.github.com/users/dinedal/events{/privacy}","received_events_url":"https://api.github.com/users/dinedal/received_events","type":"User","site_admin":false},"created_at":"2015-12-16T17:18:08Z","updated_at":"2015-12-16T17:18:08Z","body":"Released as part of V2!"}}