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

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