Duplicates of same record

[Ruegen]

I'm getting duplicates of same record in my query

SELECT [ShowPricePerStudent]*[BookingMinimum] AS CalcTaxPrice, 
IIf([GSTRegistered]=True,Format([GSTPercent],"00%") & " " & "GST","No GST") AS CalcTaxYesOrNo, 
tblJncTeacher.TeacherID, tblJncTeacher.BookingsID, tblBookings.*, tblShows.*, tblTradingAs.*, tblTeacher.*, tblStates.*, tblSchools.*, tblShows.ShowsID, tblJncShowYear.ShowsID, tblShowsGST.ShowsGSTID, tblShowsGST.GSTPercent
FROM (tblTradingAs RIGHT JOIN ((tblStates RIGHT JOIN (tblSchools RIGHT JOIN tblTeacher ON tblSchools.NewSchoolsID = tblTeacher.NewSchoolsID) ON tblStates.StateID = tblSchools.StateID) RIGHT JOIN (tblShows RIGHT JOIN (tblBookings RIGHT JOIN tblJncTeacher ON tblBookings.BookingsID = tblJncTeacher.BookingsID) ON tblShows.ShowsID = tblBookings.ShowsID) ON tblTeacher.TeacherID = tblJncTeacher.TeacherID) ON tblTradingAs.TradingAsID = tblShows.TradingAsID) LEFT JOIN (tblShowsGST RIGHT JOIN tblJncShowYear ON tblShowsGST.ShowsGSTID = tblJncShowYear.ShowsGSTID) ON tblShows.ShowsID = tblJncShowYear.ShowsID;

I can't figure out why...

[Ruegen]

I put in ShowsID from the booking table and applied group and that seems to bring it to one each..