0

combine queries

hi,
is there a way to get the document title and meta tags combined within ONE query, instead of two?

select * from html where url="http://nytimes.com" and xpath='//title'
select * from html where url="http://nytimes.com" and xpath='//meta'

thanks

Lukas

by
2 Replies
  • QUOTE (lukasmairl @ Mar 10 2010, 02:58 PM) <{POST_SNAPBACK}>
    hi,
    is there a way to get the document title and meta tags combined within ONE query, instead of two?

    select * from html where url="http://nytimes.com" and xpath='//title'
    select * from html where url="http://nytimes.com" and xpath='//meta'

    thanks

    Lukas


    CODE
    select * from html where url="http://nytimes.com" and xpath in ('//title', '//meta');


    Does this help?
    -balaji
    0
  • You can also use the strategy I suggested in http://developer.yahoo.net/forum/?showtopic=4872 which uses the query.multi table.
    0

Recent Posts

in YQL