Querries on Valentina Database

[Ruslan Zasukhin]

on 5/30/03 4:48 PM, Sandeep Rao at sandeep.rao at hurix.com wrote:

Hi Sandeep, 

> I wanted to know if valentina supports 'INNER JOIN' of 2 tables while using
> the select query.

YES

> for example I have written the query below in MS Access...
> 
> SELECT Table1.*
> FROM student INNER JOIN Table1 ON student.id = Table1.studentId
> WHERE (((student.[class id])=10));
> I have the following doubts:
> 1. Can the above be achieved using Valentina.
> 2. If yes, what is the equivalent of INNER JOIN in Valentina.
> 3. If there is no INNER JOIN available in Valentina, can you suggest a work
> around?

    SELECT Table1.*
    FROM student, Table1
    WHERE student.id = Table1.studentId AND
            (((student.[class id])=10));
     

-- 
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
-------------------------------------------------------------