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 Mike Lewis 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: swansong77
- Order by date
-
Output query and alert if there is a duplicate between 2 tables
Thanks. I am not sure If my WHERE is correct. I want it to show all MemberNumbers from table A and alert if there is a duplicate on B. I only want it to show the MemberNumber on B IF there is one on A. Can you help me re-write that? Thanks again.- swansong77
- Post #3
- Forum: Adobe
-
Output query and alert if there is a duplicate between 2 tables
I have 2 tables MembTableA and MembTableB. If a MemberNumber exists on both tables I want to somehow put an alert in my coldfusion output (I have an example "CFIF" in my code below) - and only show the 1 result from MemberTableA. Below is my query and output - can someone assist? Query in CFC...- swansong77
- Thread
- Replies: 3
- Forum: Adobe
