db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stefan Clos <mail...@gmx.net>
Subject Re: Join or Where Clause
Date Mon, 06 Dec 2004 19:24:44 GMT
hi Daniel,

i would declare the Foreign Key as unique.


Daniel Müller schrieb:

>I have 2 tables. In one table stand numbers in the secound table stand
>adresses. The have a foreign key
>The adresses table have the foreign key A_N_ID=N_ID.
>In the number table stand very much numbers. Now i wont to find out what
>numbers in the number table are free, without a relation. I wont to build a
>1:1 relation. For this I need to know what number is not set for a adress. I
>have made this statement:
>This statement works, but how i can create it with torque?
>Or is it better if I do it with right joins?
>How I do it with joins?
>Thanks for help.

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message