When I use the following statement:
select a.id, b.id from a full join b on a.id=b.id
the hsqldb doesn't support this synax. How can I change to another hsqldb surpported synax. thanks.
Of cause： I prefer a more graceful method than use left join union right join.
thanks a lot.
HSQLDB does not support FULL OUTER JOIN yet.
Log in to post a comment.
When I use the following statement:
select a.id, b.id from
a full join b
on a.id=b.id
the hsqldb doesn't support this synax. How
can I change to another hsqldb surpported synax.
thanks.
Of cause： I prefer a more graceful method than use left join union right join.
thanks a lot.
HSQLDB does not support FULL OUTER JOIN yet.