in reply to using 'IN' clause in Class::DBI
given a statement like
if you want to extend your search to more then one id, but a list obtained from another query, you canselect * from mytable where id=1
As you can see, it's related to your db and not all dbms support it.select * from mytable where id in (select id from table2)
If i understood well, you want to "narrow" your search to a limited subset of artists, having no more data i'll write an example:
Note that you can convert the IN clause with a INNER JOIN:select * from album where artist in (search artistId in artists where +year = 1990)
HTHselect album.* from album a, artists b where a.artist = b.artistId and + b.year = 1990
Oha
|
---|
In Section
Seekers of Perl Wisdom