needy monk

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I have a problem with using SELECT statements with DBD::CSV. I have to join information from 3 tables and insert into one big table. I can't seem to find any information on how to create a select statement that will enable me to select fields from more than one table the below example would work in a normal sql but not in CSV eg. $statement = $dbh->prepare("SELECT * FROM tbl1, tbl2"); $statement->execute(); please help many thanks

Comment on needy monk

Replies are listed 'Best First'.
Re: needy monk by takshaka (Friar) on Jun 10, 2000 at 11:32 UTC
DBD::CSV currently does not support joins. You'll have to compile the data manually `:(`	[reply]
RE: needy monk by t0mas (Priest) on Jun 11, 2000 at 23:23 UTC
From pod: The current version of the module works with single table SELECTs only, although the basic design of the SQL::Statement module allows joins and the like. So the answer is: Do it yourself. If someone did this (plus some other stuff) to CVS it would be very useful. /brother t0mas	[reply]