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?

Current Code:

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.

What is the Column with which you are making the join between T_ProgramGuests and T_ProgramLinks tables? How about posting the structure of the tables here?

_________________________
- Vijay G
Strive for Perfection

To only get one record, make sure that there is only one record in your T_ProgramLinks table. If there are multiple records in that table which have different URL values, then you have to put a JOIN condition or a WHERE clause that will return just 1 URL value.

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp