Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: ronfranks1
- Order by date
-
Need Help With SQL Statement
This SQL needs to return 1 NEW record, marked "NEW", and only 1 old record, marked "OLD", if one existed before. The problem is, I am returning multiple OLD records that have a different dates from table2. This is what I want: 12345 New 12345 Old This is what I don't want: 12345 New 12345...- ronfranks1
- Thread
- Replies: 1
- Forum: ANSI_SQL
