Welcome to Soft32 Forums!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SprintDB help needed

 
   Soft32 Home -> PDA -> Pocket PC General RSS
Next:  Calender on pc to Pocket pc  
Author Message
Stefan Florin

External


Since: Feb 01, 2004
Posts: 1



(Msg. 1) Posted: Sat Jan 31, 2004 10:36 pm
Post subject: SprintDB help needed
Archived from groups: microsoft>public>pocketpc (more info?)

Dear Friends,

I'm using too the SprintDB and I'm really impressed.
I would like to have some friends with the same hobbies like me and to
exchange from time to time some ideas.
Wouldn't be nice?

I have a question to ask you: have you ever need to write a SELECT
statement in order to get some information from a table excluding the
same articles existing into another table? Something like a
difference.

Here is an example of what I want to solve:

We have two tables, t1 and t2.
In t1 we have, by example, the employees.
In t2 we have the employees who were noted with bad mistakes. The
problem that we have to solve is: how to write a SELECTION in
order to select in a table only the employees who are not included in
the t2 "mistakes" table.

t1 fields
ID - indexed autoincremental
name - text, indexed
age - number
position - number
t2 fields
ID - indexed autoincremental
name - text, indexed
observation - text

Dates:
t1
1, John, 32, director
2, Jane, 40, secretary
3, Gill, 28, technical
4, Bete, 39, warehousekeeper
5, Stefan, 22, driver

t2
1, Gill, delays on scheduling
2, Stefan, driver license suspended

The tables cannot be one.

Do you think it can be solved? And how?

I would verry much appreciate if you can help me...

Best regards,
Stefan Florin
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SD Card Help needed - I have a Packard Bell Pocket Gear 2030 using Microsoft Pocket PC 2002 and have just got my first 32mb SD Card, I put th...

Global Convergent Device Needed - I am looking for a device which allows for PDA functionality, ability to send/receive email anywhere in the world, an...

Microsoft Money Pocket PC Help Needed - I have recently installed a Microsoft Money 2002 Deluxe that I recieved in the mail. My Pocket PC will no longer Syn...

Battery replacement needed for IPAQ 3635 - Can anyone tell me where I could send my Ipaq 3635 for a battery replacement that is reliable and not expensive? Compa...

Major Help Needed! - Infuriating 802.11b Problem - I need major help on my Dell Axim 3Xi. I have been able to surf on the Net with my wireless 802.11b home network until ...
       Soft32 Home -> PDA -> Pocket PC General All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum

Categories:
 Windows
 Linux
 Mac
  PDA


[ Contact us | Terms of Service/Privacy Policy ]