How to do a transitive join? #880
dufferzafar
started this conversation in
General
Replies: 1 comment
-
|
This is not possible at the time. The only solution is to duplicate the venue data in your position table. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I have three tables:
positions,venues,priceswith the following schema:I want to join the positions table with the prices table, but notice how the positions table has no
venuecolumn - but the venues table does!This is the join I have right now:
I now want to use the venue from the above join, to join positions with price:
This gives me a
KeyError: 'venues.venue' since positions table doesn't have that column.How can I access the column venue from the venues table via the positions table since I've already made that join.
Or is there some other way of making this transitive join?
Beta Was this translation helpful? Give feedback.
All reactions