Join seem to implemented... Is it?

Posted on 2005-02-26 21:47:05-08 by lucir

I've just tried DBD::AnyData.

My first effort was to parse 2 XML files and to inner join them. It worked well. Then I read documentation :) and saw that

DBD::AnyData does not currently support using multiple tables in a single SQL statement. However it does support using multiple tables and querying them separately with different SQL statements. This means you can simulate joins by creating two statement handles and using the values from the first handle as a lookup key for the second handle.

Both statements worked:

SELECT foo.id, foo.data, bar.data FROM foo INNER JOIN bar ON foo.id = bar.id

SELECT foo.id, foo.data, bar.data FROM foo, bar WHERE foo.id = bar.id

What does it mean? Is the subject already implemented in DBD-AnyData or the work is done by DBI module itself?

I use DBD-AnyData 0.08, DBI 1.47

Direct Responses: 157 | Write a response

Perl Weekly newsletter
A free weekly newsletter for people who are busy to read all the blogs. click here to check it out.