SQL syntax help with a subquery - Level Extreme

Message

From

30/11/2006 19:37:23

Aaron Hudon
British Columbia, Canada

To

30/11/2006 19:22:09

Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: SQL syntax help with a subquery

Environment versions

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Network:

Windows NT

Database:

MS SQL Server

Miscellaneous

Thread ID:

01173944

Message ID:

01173956

Views:

10

Thanks for the reply.

Unfortunately, this query returns more than one child record for the same parent.