* Henning Sprang
> Now I want to create a query to get all task_id's which one given User
> isn't already assigned to. I tried a lot of things, Joined in every
> direction and so but do not come to my result.
The problem in this situation is that you want to join with records that are
not there.
Hy,
I have a question on how to build a query.
scenario:
I have three tables,
Users:
--
user_id INT(32),
username CHAR(64)
Tasks:
--
task_id(INT32),
task_name CHAR(64)
Authorization:
--
user_id INT(32),
task_id INT(32)
some details of database design are neclected here.
>hi all together!
>
>i'm turning to your mailinglist as last chance to find s.o. helping
>me with my problem.
>
>the situation is as follows:
>
>i got a table on a mysql-database, queriing it by php4. the table
>consists of all planets of the planetarion.com-system. these
>information consists
Hello.
On Thu, Jun 28, 2001 at 10:48:23PM +0200, [EMAIL PROTECTED] wrote:
[...]
> the user inserts some wished dates (the lowest score, the searched
> planet may have, the highest, the highest number of roids and the
> lowest..) and the number-interval in wich the _galaxy-score_ may be
> included
hi all together!
i'm turning to your mailinglist as last chance to find s.o. helping me with my problem.
the situation is as follows:
i got a table on a mysql-database, queriing it by php4. the table consists of all
planets of the planetarion.com-system. these information consists of each 3
c
