How to write an SQL query in unix?
September 13, 2011 9:19 AM Subscribe
I'd like to perform an SQL query with outer joins, from text files on my PC, using only a unix emulator. Is this possible on my PC? How would I write and execute it?
posted by RobinFiveWords to computers & internet (16 answers total)
I need to left-join A to each of B and C, and because of the size of A, Microsoft Access can't handle the joins. The results will contain about 1.5 million rows. There are actually dozens of A tables, and I need to run the same query for each A, then further study the results.
HP Compaq nondescript laptop, Windows XP, cygwin as my emulator, Oracle 9.2 installed. My experience with unix doesn't go much beyond manipulating text files, but I have a good programming background. Each discussion I've found via Google, though, starts well beyond my level, so I'm lost before I begin. Any pointers on how I can learn what I need to know?