Hi,
try this on psql console:
explain analyze select tq1.*, tq2.* from
cal_quat_1 tq1, cal_quat_2 tq2
where tq1.timestamp = tq2.timestamp
and tq1.timestamp '2004-01-12 09:47:56. +0'::timestamp with time zone
and tq1.timestamp '2004-01-12 09:50:44.7187 +0'::timestamp with time zone
order by
Randall Skelton wrote:
Greetings all,
I am trying to do what should be a simple join but the tables are
large and it is taking a long, long time. I have the feeling that I
have stuffed up something in the syntax.
Here is what I have:
telemetry= select (tq1.timestamp = tq2.timestamp) as