[EMAIL PROTECTED] wrote: > Only versions of SQL::Statement 1.0 and above support additional > features such as table joins, string functions, etc. See the > documentation of the latest version of SQL::Statement for details. > > But, even though I have the latest version of SQL::Statement (which > supports table joins) installed I am getting the following error: > 'DBD::CSV::db prepare failed: Parse error near tab2 WHERE tab1.col1 LIKE > 'test1%' AND tab1.col1 = tab2.col2 at > /usr/local/perl/5.6.0/site_lib/DBD/File.pm line 174.'
I can't help unless I see the code that caused the error. Please show me the prepare statement (including the full SQL) for the line that caused the error. > I want to know if table joins are supported in DBD::CSV, Yes, as stated in the documentation you quoted above. > supported then from which versions of the depending modules I will have to > install. Version 1.0 or above, as stated in the documention you quoted. The latest is version 1.004. To find out what version your script is actually using (in case you have several versions installed) put this near the top of your script: use SQL::Statement; print $SQL::Statement::VERSION; -- Jeff
