rds,
=dn
- Original 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
>
* 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
Hi DN,
Boy SQL is damn powerful!!!
I see what you mean by having my head switch the way it is thinking and
a lot of penny's dropped this afternoon, Thankyou.
In the end I did this:
SELECT studentname_27.objectives_id,
studentname_27.data,
staff.name,
studentname_27.date,
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