[This topic is migrated from our old forums. The original author name has been removed]
It would be sweet if the sql editor could auto complete join between my tables.
(1) Say i write:
select * from table1 t1, table2 t2
when I hit som key shortcut (for example ctrl, shift, space)
then the editor auto completes the join statements between my tables from their foreign keys
select * from table1, table2
where t1.a = t2.a
and t1.b = t2.b
(2) or...
select * from table1
join table2
... to ...
select * from table1
join table2
on t1.a = t2.a
and t1.b = t2.b
(3) or...
select * from table1
join table2
join table3
... to ...
select * from table1
join table2
on t2.a = t1.a
and t2.b = t1.b
join table3
on t3.c = t2.c
1 person likes this idea
1 Comment
Roger Bjärevall
said
over 15 years ago
[This reply is migrated from our old forums.]
Re: Auto complete join in sql editor
Jens,
We'll register this as a feature enhancement request.
Thanks!
Best Regards
Roger
anonymous
1 person likes this idea