Create a view from the union of two table

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Create a view from the union of two table

Message

From

01/04/2004 03:11:55

31/03/2004 20:38:58

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Miscellaneous

Thread ID:

00891335

Message ID:

00891381

Views:

You cannot create view
with UNION into the VFP view builder
but you can define the view with code.

CREATE SQL VIEW viewUnion as;
SELECT * FROM dbctry!Table3;
union all;
SELECT * FROM dbctry!Table3