CREATE TABLE "deleteion" control

[Ruslan Zasukhin]

on 8/19/03 21:55, Andrew Sinning at andrew at learningware.com wrote:

> What does using an ObjectPtr mean with regard to "NATURAL" joins?  In
> otherwords, do I still need to make the relationship between two tables
> explicit with a WHERE t1.fieldName *= t2.fieldName, or is the
> relationship automatic?
> 
> So, I have
> 
> TABLE games
> gameId UNIQUE
> gameName
> 
> TABLE questions
> questionId UNIQUE
> gameId REFERENCES games
> 
> 
> So, if I want to select questionId 275 along with it's parent game, can
> I just use
> 
> SELECT * FROM questions, games WHERE questionId = 275

YES!
 
> or do I need to specify: AND questions.gameId *= games.gameId

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------