Views and SQL 7

[BlackKnight]

Hi folks,

Can I join a table or view to a view in a SQL 7 statement? ViewA would be a select query returning a recordset.
For instance: TableA LEFT JOIN viewA

If it is possible please provide the statement's syntax.
Thanx in advance.

Have a good one!
Keith

 

[swilliams]

Create a view and save. The create another view using the other table and the view you have just created. treat the view as if it were another table.

Simon