Convert command into sql query

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Convert command into sql query

Message

From

15/01/2008 13:01:24

15/01/2008 12:49:25

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Environment versions

Visual FoxPro:

VFP 9 SP2

OS:

Windows XP SP2

Network:

Windows 2000 Server

Database:

Visual FoxPro

Miscellaneous

Thread ID:

01281878

Message ID:

01281968

Views:

>Or even easier
>

>insert into ExamTran (code, OneField);
>select code,"StaticInfo" as OneExtraField from students where code not in (select code from ExamTran)
>

Right, I thought about it too.

If it's not broken, fix it until it is.

My Blog