I have a view that looks at new student records and a table that stores those records and information related to their Active Directory logins. What I need to do is filter out any duplicate records between the two "tables". So I only see unique records in the view to be added to the table.

Geek-Master
Recommended Answers
Jump to Posttry DISTINCT
eg: select distinct * from table1 join table2 on blah...
Jump to PostThe ON clause will only look for ID numbers that are equal to each other.
No the default JOIN specifys only records that match, the default join is INNER.
LEFT OUTER JOIN (can be abreviated to LEFT JOIN) means all records in left table whether there's a match in …
All 8 Replies

Geek-Master
hollystyles
113
Veteran Poster

Geek-Master

Geek-Master
hollystyles
113
Veteran Poster

Geek-Master
hollystyles
113
Veteran Poster
hollystyles
113
Veteran Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.