Avoid the _a and _b when selecting * from both tables? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Avoid the _a and _b when selecting * from both tables?

Message

From

12/10/2004 16:46:04

Jay Johengen
Altamahaw-Ossipee, North Carolina, United States

To

12/10/2004 16:41:46

Naomi Nosonovsky
Wisconsin, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Avoid the _a and _b when selecting * from both tables?

Miscellaneous

Thread ID:

00950839

Message ID:

00950846

Views:

13

So, you must know the field names in order to avoid the "_a" or "_b" for same-named columns? What a pain.

>Either explicitly name all fields or alter table afterwards. You don't have a 3rd choice.

Click here to load this message in the networking platform