On 2011-08-09 14:03, Eugene Prokopiev wrote:
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?
You could try using some aliases: select a.sumdate from summary_ip_in('wan') as a inner join summary_ip_out('wan') as b on a.sumdate = b.sumdate limit 1; -- Sjoerd Mullender