Preventing repetition with Distinct?
Whenever I add a table in my query designer and checkmark Links it causes the guest names to be repeated. If I don't do this the query result is correct. So how do I prevent name repetition but yet add links to the display?
SELECT DISTINCT GuestName, GuestDescription FROM T_ProgramGuests WHERE (ProgramID = 9734)
Link Added to Code:
SELECT DISTINCT T_ProgramGuests.GuestName, T_ProgramGuests.GuestDescription, T_ProgramLinks.URL
FROM T_ProgramGuests CROSS JOIN T_ProgramLinks WHERE (T_ProgramGuests.ProgramID = 9734)
Even if I use a Left Outer Join I get the same.