[SQL] DBD::Pg transaction issues

2003-04-06 Thread Raj Mathur
Hi, Am using DBD::Pg with PostgreSQL 7.2.3, Perl 5.8.0. I have a set of updates to a table which has (a) references to another table and (b) possibly duplicates. The data is in a text file, which is read record by record and appended to the database table. A transactions spans the complete read

Re: [SQL] Extraordinary Full Join

2003-04-06 Thread CN
Thank you! Josh, > You'll need to add an "sort_no" column to both tbook and thobby, and > ensure somehow that both tables have the exact same sequence of sort numbers. > Then you can: > > select tmaster.id, tmaster.name, tbook.book, thobby.hobby > from tmaster, tbook, thobbby > where tmaster.id