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
)