Sybase Technical Library - Product Manuals Home
[Search Forms] [Previous Section with Hits] [Next Section with Hits] [Clear Search] Expand Search

Qualifying Names [Table of Contents] The FROM Clause

Sybase IQ Query Guide

[-] Chapter 2: Using Queries
[-] Retrieving Data from Tables
[-] Selecting Data from Multiple Tables

Selecting Data from Multiple Tables

You can retrieve data from multiple tables in a single SELECT statement if the tables are joined together in that statement. Tables in associated main and private indexspaces (as specified in sysIQ_logins) may be joined in any statement that supports ad hoc joins (including the SELECT statement and the INSERT...SELECT statement).

Note: You must create and preallocate a private indexspace with the IQ CREATE INDEXSPACE command and associate it with the main indexspace in sysIQ_logins using the sp_IQAddLogin stored procedure.

As with a standard SQL join, a Sybase IQ join combines rows from two or more tables. Each combination is based on the join condition between columns specified in the WHERE clause. Chapter 4, "Retrieving Data from Multiple Tables," describes joins in detail.

Compliance with Transact-SQL and SQL-92


Qualifying Names [Table of Contents] The FROM Clause