>>>
>>>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