[MonetDB-users] JOIN for functions

9 Aug 2011

      Hi,

Is it possible to join functions which returns tables? I've got error:

sql>select sumdate from summary_ip_in('wan') limit 1;
+------------+
| sumdate    |
+============+
| 2-08-11    |
+------------+
1 tuple (1m 14s)
sql>select sumdate from summary_ip_out('wan') limit 1;
+------------+
| sumdate    |
+============+
| 2-08-11    |
+------------+
1 tuple (10m 59s)
sql>select sumdate from summary_ip_in('wan') inner join
summary_ip_out('wan') on summary_ip_in.sumdate =
summary_ip_out.sumdate limit 1;
SELECT: no such column 'summary_ip_in.sumdate'
sql>select sumdate from summary_ip_in('wan') inner join
summary_ip_out('wan') on sumdate = sumdate limit 1;
SELECT: identifier 'sumdate' ambiguous

What's wrong?

--
Thanks,
Eugene Prokopiev