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