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 gkittelson 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: rotorblade
- Order by date
-
web server and java?
Apache's Jakarta-Tomcat is probably your best bet to get started. Download for your platform, install, read the docs, write some Servlets or JSPs, and have fun. http://jakarta.apache.org/tomcat/index.html- rotorblade
- Post #2
- Forum: Java
-
Where clause for only recs that match all in 2nd table.
I did consider that. The PK for table B is (id, filter) so uniqueness shouldn't be a problem.- rotorblade
- Post #7
- Forum: ANSI_SQL
-
Where clause for only recs that match all in 2nd table.
Well, I got an answer from another source that is similar to but simpler than that suggested by r937. In case anyone is interested, the trick was to use GROUP BY and HAVING COUNT(A.id) = x, where x is calculated in the application program code at the same time the list of filter values is...- rotorblade
- Post #5
- Forum: ANSI_SQL
-
Where clause for only recs that match all in 2nd table.
Okay I shouldn't have complicated things by even including the description column in table A. Its value is only to demonstrate the desired results. Suppose that instead of the description column, table A had a completely unrelated column called blob_data. My objective is to select all...- rotorblade
- Post #4
- Forum: ANSI_SQL
-
Where clause for only recs that match all in 2nd table.
I'm trying to retrieve only records from table A joined to table B where A.id = B.id and there is a matching record in table B for EVERY value in a list of values for B.filter. For instance, given the following two tables: -------- Table A ---------- | id | description |...- rotorblade
- Thread
- Replies: 8
- Forum: ANSI_SQL
