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!
Recent content by markbabcock
-
SQL HELP
R937 Thanks for all your help that seems to be the result set I was looking for. Now to look at what the says.. inner join with a sub query.. Yippie.. my head already hurts..but thanks.- markbabcock
- Post #7
- Forum: ANSI_SQL
-
SQL HELP
lets start with table2 +---------+-----------+---------+-----------------------+ |ID2 (PK) | ID1 (FK) |SendTO | Datetime | +---------+-----------+---------+-----------------------+ | 1 | 1 | mark | 10/25/2003 14:23:00 |...- markbabcock
- Post #5
- Forum: ANSI_SQL
-
SQL HELP
You say the data is inconsistant. I will try to clarify. table a holds a generic message (subject) and I need to see the user in table2 who has the message. does that help any?- markbabcock
- Post #3
- Forum: ANSI_SQL
-
SQL HELP
I have a SQL Question I was wondering if anyone can help me with. I have two tables that have the following structure: table1 +--------+-----------------------+ |ID1 (pk)| subject | +--------+-----------------------+ | 1 | math | +--------+-----------------------+ |...- markbabcock
- Thread
- Replies: 6
- Forum: ANSI_SQL
