Solved very simple, but can't figure it out

[TipsyWolf]

hey guys,
how do i call a query to show me only whose ID from Tmain (parent) that doesn't have any records in Tactions. (child)

so i have

i tried to set "not equal" but doesn't work.

sql

SELECT tmain.riskid, Tactions.RiskID, [RiskID]<>[RiskID] AS Expr1
FROM tmain INNER JOIN Tactions ON tmain.RiskID = Tactions.RiskID;

 

[arnelgp]

SELECT tmain.riskid, Tactions.RiskID FROM tmain LEFT JOIN Tactions ON tmain.RiskID = Tactions.RiskID WHERE ((Tractions.RISKID) IS NULL);


//Edited Jeft with Left

 

[TipsyWolf]

SELECT tmain.riskid, Tactions.RiskID FROM tmain JEFT JOIN Tactions ON tmain.RiskID = Tactions.RiskID WHERE ((Tractions.RISKID) IS NULL)

 

[Gasman]

Loving God
It is a typo, LEFT not JEFT :-(

There is also a wizard for that

 

[TipsyWolf]

Loving God
It is a typo, LEFT not JEFT :-(

There is also a wizard for that
View attachment 116138

facepalm

 

[TipsyWolf]

thank you, guys