"UNION ALL" in OBDC for Topspeed

[miguelalemantajin]

Hi guys. Nice to meet you ... please somebody help me with this stuff.

I have an ODBC for access TopSpeed files.
I have experience working with another DBMS like Sql Server.
What I want is to make a query by joining two queries.

Example:
query 1:
select student_studentid, student_grade, tutor_tutorid
from tblstudent, tbltutor where student_studentid=tutor_studentid
UNION ALL
select student_studentid, sutdent_grade, teacher_teacherid
from tblstudent, tblteacher where
student_studentid=teacher_teacherid


Please consider that the 3 fields in both queries have the same type of data.

My question is ... for an ODBC for Topspeed wich command is the equivalent of UNION ALL in Sql Server?

Thanks in advance (Miguel)

 

[ShankarJ]

Hi Miguel,

I don't think TS-ODBC supports the UNION operator. Check specs at :

http://www.softvelocity.com/products/database_tsodbcspec.htm

Regards