Suggest WHERE conditions
Let's say, there are tables A and B linked with a foreign key.
Currently, dbForge SQL Complete suggests joining conditions:
SELECT *
FROM dbo.A a
JOIN dbo.B b ON ->> a.id = b.id
As part of this feature, dbForge SQL Complete could also suggest conditions in the following queries:
SELECT *
FROM dbo.A a
OUTER APPLY (
SELECT TOP 1 *
FROM dbo.B b
WHERE ->> a.id = b.id
) t
SELECT
*
, (
SELECT TOP 1 ', '
FROM dbo.B b
WHERE ->> a.id = b.id
)
FROM dbo.A a
SELECT *
FROM dbo.A a
WHERE NOT EXISTS(
SELECT 1
FROM dbo.B b
WHERE ->> a.id = b.id
)
SELECT *
FROM dbo.A a
WHERE a.name IN (
SELECT b.name
FROM dbo.B b
WHERE ->> a.id = b.id
)
![](https://secure.gravatar.com/avatar/ebf67e4a99ded189c9425f709b9b138b?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)