code completion of correlated subqueries and where exists ( .. )
Hi
Love DbForge but I find I'm always writing this sort of query
UPDATE
client
SET
client.foo = 0
WHERE EXISTS
(
SELECT
1
FROM
clientRegion
WHERE
clientRegion.clientId = client.id AND ....
)
it would be ideal if dbforge could recommend some completions for the correlated portion inside the ( ) based on fk's in the same way it does for joins.
1
vote
Willem
shared this idea