Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's Wrong With This????
Message
De
08/08/2011 13:47:20
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
01520346
Message ID:
01520423
Vues:
43
>>>
>>>SELECT u.id, u.campaign_id, u.user_id, u.query_name, u.query_desc, v.voter_id
>>>	FROM universes u
>>>	JOIN universe_xref_voters v ON v.universe_id = u.id
>>>	WHERE u.Campaign_Id = 134 
>>>	ORDER BY u.Query_Name
>>>
>>>
>>>Notice that I'm getting the universes tabel repeated 3 times. I should be getting back all 4 universe roes with a voter Id added on.
>>>>My ultimate goal is to get a result set of universes with a count of voters assigned to each, but I can't get past this.
>>you Need a Left join grouped on the id and a Field to Count the Universe recs.
>>Typung on the pad is Not so Great for Code - you should get the idea.
>>
>>Regards
>>
>>Thomas
>
>Which pad did you get? I am also a fan (don't have one yet) but can well imagine typing code is not its forte.

Currently eval'ing a couple - I like the 7' form factor and mostly use it as WLAN front end.
Tried the Samsung and the Archos 7', currently Ipad1 (will need to buy ~60 for utility customer,
price IS important for the client) - nice OS but don't like the hoops for connectivity.
Loading the iPad takes too long and sometimes I wonder if there is a small current
in the metal case if handled while loading. Metal body is nice, but plastic an isolator ;-)

Also Flash IS used on some sites I liketo browse to -
some stock sites work better or only with flash.
Refreshed my previous take, although the ease for a device 1 year old is great.

Looking forward to Android 3 systems, but for me personally the Pads will stay 95%reading devices -
The 7' handle like a pocket book - probably either the Samsung 8.9 or one of the 7' will be mine in Q4,
when testing is done.

On the personal side: congrats for posting less quantity but more quality -
having part your time occupied by GF and job seems to be a definite plus.
On re-reading: could be interpreted abigously -
but you should know me well enough to know this is a compliment ;-)

Hope you still find some time for sports to have a better structure
for the possibility when not everything is smooth sailing.

regards plus crossed fingers

thomas
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform