Hello,
Several IDs noted by several sources. I would select all the IDs that are observed by all three sources. This applies only to data from the past 24 hours.
So far I have:
Select *
From db
Where id in ( Select id
From db
Where source = source_1)
And id in ( Select id
From db
Where source = source_2)...
Aldert
Last Activity: Jul 14 '09, 09:19 AM
Joined: Jun 29 '09
Location:
-
Optimize query
Hello people,
I have a complex question.
Imagine a supermarket where all sold products are written in a database. The sources are three cash registers. The database will continue filled with new data. I will:
- From a certain product (for example, "JAM", this product is part of a table 'products' in which these specific products are named) the data request which is received in a 30 second after the...Last edited by Atli; Jun 29 '09, 06:52 PM. Reason: Added [code] tags and formatted the query to make it readable.
No activity results to display