accessing related foreign tables via sql operator
Hi, I have three tables. A url table, a redirect table and a request table. The schema looks like the following,
Given a url id, I'm trying to access the ip key. My query looks like the following,
I'm trying to count the unique number of ip addresses in the requst table with the
sql
operator but when I try to do something like url.request.id
. It doesn't exist in url table. Can someone help. : )![No description](https://cdn.answeroverflow.com/1155258946563604480/image.png)
0 Replies