Message -
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Mark Worsdall [EMAIL PROTECTED]
Sent: 27 January 2002 17:32
Subject: RE: Can this can be done in a single SQL statement?
* Mark Wordsall
So there is no join is this sql statement, I say this cos I see no word
saying
Hi Mark,
Can anyone tell me if this can be done in a single SQL statement?
This sounds like solving the problem in procedural logic. Try putting that aside
and/or converting to relational
logic. As to the complexity of working with so many tables, its realisation is
startlingly simple once
$7215100a@jrbrown, DL Neil
[EMAIL PROTECTED] writes
Hi Mark,
Can anyone tell me if this can be done in a single SQL statement?
This sounds like solving the problem in procedural logic. Try putting
that aside and/or converting to relational
logic. As to the complexity of working with so many tables, its
* Mark Wordsall
So there is no join is this sql statement, I say this cos I see no word
saying JOIN?
Yes, there are. The comma separating table names in the FROM clause are
synonyms for 'INNER JOIN', and the actual joining is done in the WHERE
clause, where you match the different tables, in