The SQL intersect operator returns rows that are common between two tables without returning duplicate records.
Questions tagged [intersect]
643 questions
0
votes
3 answers
Find rows from the results of one query that meet another requirement
I have the following table, product_taxonomy_id:
| product_id | taxonomy_id | value_id |
+------------+-------------+----------+
| 1 | 2 | 4 |
| 1 | 1 | 1 |
| 2 | 1 | 1 …
Josep
- 53
- 1
- 8
0
votes
1 answer
SQL errors when using INTERSECT operator
I'm trying to find results that are found by both a category-based search and a keyword search. But in phpMyAdmin, this code is bringing up errors:
SELECT ID, post_title
FROM wp_5_posts AS p
LEFT JOIN wp_5_term_relationships AS r ON p.ID =…
Jake Howland
- 3
- 1
0
votes
1 answer
Adding a new player with keys WASD
I am really new to programming. For my class, I am making a game and I would like to add a seconds player to the game. At the moment, there are black circles that appear randomly in the game and keep growing. You are a circle and you need to avoid…
Dillon
- 9
- 2
0
votes
2 answers
intersect/collision with bitmap and rectangles
I've been trying to write code when the coordinates cx/cy intersect with a rectangle/s the rectangle changes color. This has been driving me up the wall. Here is my code for the rectangles.
for(int k = 0; k<=15; k++){
k = k * 55;
…
Mag
- 11
- 1
0
votes
1 answer
Creating multivalue search, struggling with SQL
Based on user input, which could be a single or multiple values, and using the following table
+------+--------+
| seed | item |
+------+--------+
| 1 | apple |
| 1 | grapes |
| 2 | apple |
| 3 | grapes |
| 3 | banana…
Rosheph Jackson
- 55
- 6
0
votes
3 answers
Linq intersect to filter multiple criteria against list
I'm trying to filter users by department. The filter may contain multiple departments, the users may belong to multiple departments (n:m). I'm fiddling around with LINQ, but can't find the solution. Following example code uses simplified Tuples just…
Dennis G
- 21,405
- 19
- 96
- 133
0
votes
1 answer
intersecting faces in sketchup rupy
When I draw simple two faces I ended up with those faces not like in sketchup e.g drawing two intersected faces...
face1 = ent.add_face([0, 0, 0], [20, 0, 0], [20, 20, 0], [0, 20, 0])
face2 = ent.add_face([5, -5, 0], [10, -5, 0], [10, 25, 0], [5,…
Sami Abdelgadir Mohammed
- 253
- 1
- 6
- 15
0
votes
1 answer
Lambda statement Intersect
Trying to work out this lambda query without doing a foreach etc. I currently have a database table with a column which contains a comma separated list of strings. It's basically a filter (it could for example be 'pants,tops,t-shirts,gloves'). In…
user2761804
- 89
- 5
0
votes
1 answer
MySQL: Intersect rows that match a certain number of characteristics
This is a little tough to explain, but here goes. I have a database of books, and in it two tables.
One for unique book keywords, i.e. just attributing an ID to each keyword:
id | keyword
______|____________
k1 | drama
k2 | …
vinsanity555
- 241
- 1
- 11
0
votes
2 answers
Null pointer in an intersecting method with arrays (java)
Exception in thread "Thread-1" java.lang.NullPointerException
at java.awt.Rectangle.intersects(Rectangle.java:786)
at Robotron.intersecting(Robotron.java:182)
at Robotron.run(Robotron.java:349)
at…
jaronoff97
- 366
- 3
- 15
0
votes
3 answers
SQL Server : compare two tables with UNION and Select * plus additional label column
I've been playing around with the sample on Jeff' Server blog to compare two tables to find the differences.
In my case the tables are a backup and the current data. I can get what I want with this SQL statement (simplified by removing most of the…
StillLearnin
- 1,391
- 15
- 41
0
votes
1 answer
Python comparing two dictionaries with multiple values per key and retrieve common values
I'm a beginner and I need help with my code.
I have two files in list format that I would like to use as dictionaries. Both files are in the same format. Column 1 has the key and column 2 has the associated values separated by "|". All keys may…
rod12160
- 5
- 4
0
votes
1 answer
interval overlapping in tsql
i need to get splited intervals and the number of overlapping intervals, eg
basedata:
interval A: startTime 08:00, endTime 12:00
interval B: startTime 09:00, endTime 12:00
interval C: startTime 12:00, endTime 16:00
interval D: startTime 13:00,…
Nico
0
votes
1 answer
Range is not accessible to Application.Intersect
I cannot seems to access a VBA defined range ("DateRange") within Application.Intersect.
Using Application.Intersect(DateRange,Cellref) gives the error "Object required"
The range is able to be copied to another sheet and the address can also be…
user3180258
- 97
- 13
0
votes
1 answer
Issue whenever round images intersect with CGRect in Xcode
In my application I have it so that whenever two round images intersect with each other the game ends, but the problem that I am seeing is that the two images are actually intersecting before they actually touch one another. I have tried multiple…
user3321574
- 3
- 2