0

YQL tables

Hi All,

I see lot of tables with show tables command in YQL table. How can i learn about how to join these tables ?. For example, if I want to list the status of all my connections, I dont know how to join the necessary tables.

Is there any documentation on these tables that descirbes how they relate to each other?

Thanks,

Vissu

by
2 Replies
  • Hi Vissu Y,

    Joins in YQL are implemented via "sub-select". The "Example Queries" section on the right of the console has a few sub-select examples: "get all my friends profiles", "get my friends nicknames", "get my last added friend", ...

    Here's an example in the YQL console that lists the status of each of your connections:
    http://developer.yahoo.com/yql/console/?q=...wner_guid%3Dme)

    Here is some documentation on using sub-select statements in open tables:
    http://developer.yahoo.com/yql/guide/yql-o...s-batching.html

    Here's a post on Jonathon Trevor's blog that uses sub-select with the weather api:
    http://jonathantrevor.net/?p=40

    Please post back if you have any questions.

    Erik


    QUOTE (Vissu Y @ Apr 29 2009, 06:54 PM) <{POST_SNAPBACK}>
    Hi All,

    I see lot of tables with show tables command in YQL table. How can i learn about how to join these tables ?. For example, if I want to list the status of all my connections, I dont know how to join the necessary tables.

    Is there any documentation on these tables that descirbes how they relate to each other?

    Thanks,

    Vissu
    0
  • QUOTE (Vissu Y @ Apr 29 2009, 06:54 PM) <{POST_SNAPBACK}>
    Hi All,

    I see lot of tables with show tables command in YQL table. How can i learn about how to join these tables ?. For example, if I want to list the status of all my connections, I dont know how to join the necessary tables.

    Is there any documentation on these tables that descirbes how they relate to each other?

    Thanks,

    Vissu


    Erik I think has provided you with a lot of great info.

    Actually knowing what you can join between tables is something we're looking at making easier and can be trick to start with.

    I find the easiest way is to think about what "keys" a table accepts (like zipcode or weather location id, or woeid etc) and what values/keys a table produces. If they are the same type of thing, then you can join them using IN.

    Jonathan
    0

Recent Posts

in YQL