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 IamaSherpa 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: coolgeek1987
- Order by date
-
comparing arbitrary sets
ah, just found the MySQL forum... I'm usually pretty good on my own - I've been developing on Oracle since 7.3 - but I'm much more of a general programmer than a SQL guru. Thanks again- coolgeek1987
- Post #5
- Forum: ANSI_SQL
-
comparing arbitrary sets
r937 - That seems to do the trick. Thanks a lot - especially since I just found out that MySQL doesn't seem to support intersect. I'm going to have to check out your book!- coolgeek1987
- Post #3
- Forum: ANSI_SQL
-
query where statement two row in same column
you need to use intersect select dm_id from table where sy_id = 1 intersect select dm_id from table where sy_id = 2 will return only the dm_id value = 1- coolgeek1987
- Post #13
- Forum: ANSI_SQL
-
comparing arbitrary sets
I've got a user table and a book table, with a fact table recording the books read by each user. For simplicity, the tables and their fields are: Table Fields ----- ------ user user_id book book_id books_read user_id, book_id I have a web app that lets a user...- coolgeek1987
- Thread
- Replies: 4
- Forum: ANSI_SQL
