Re: De-Normalized output to CSV

From: Damjan S. Vujnovic <damjan_at_NOSPAMgaleb.etf.bg.ac.yu>
Date: Fri, 31 Jan 2003 09:20:45 +0100
Message-ID: <b1dbjj$50o$1@news.etf.bg.ac.yu>

>> Why not just query as joins, then output the query into CSV format? For
instance, if you have TableA, TableB, and TableC, and they all get joined together, then run the following query:

SELECT ......
FROM TableA a, TableB b, TableC c
WHERE a.somecolumn=b.somecolumn
AND b.somecolumn=c.somecolumn;

It is now de-normalized and you should have no problems converting to CSV format. <<

Seems that you are suggesting an INNER join, but it's not a good idea IMO because not all touples from all tables will be present... Outer join might be a better idea, but I still dislike this approach (and I don't know any better, though I'm curious if one exists).

regards,
Damjan S. Vujnovic

University of Belgrade
School of Electrical Engineering
Department of Computer Engineering & Informatics Belgrade, Yugoslavia

http://galeb.etf.bg.ac.yu/~damjan/ Received on Fri Jan 31 2003 - 02:20:45 CST