|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Hi, I need to produce the following query:
'customers who have used a specific suppliers web service, more than 30 times between 2 specific dates' (I have several tables including a supplier, customer and supplier web service table). Any ideas?? thanx a lot!! |
|
#2
|
|||
|
|||
|
See if this helps or sparks some ideas that is more specific to your environment.
Select custFN, custLN, c.custid From customer c Join Supplier s On c.custid = s.custid join supplier_webservice sws On s.custid = sws.custid Where usage > 30 And usagedate Between date1 And date2 |
|
#3
|
|||
|
|||
|
Okey dokey, thanx a lot..I'll have a look and think about that one!
![]() |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Help required on query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|