Linking text files

[tollesbury]

I have two text files, one with product availability and the other with pricing
and want to join the two together to produce a price list. I have created two
recordsets using txt drivers and this works fine. When trying to create another
recordset with a JOIN between the two files I can't.
Is it just a naming issue in the SQL or is it impossible?

Andrew

[Paul Whitham TMM]

For a join to work both files must have exactly the same fields names and
field types.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"tollesbury" <webforumsuser@macromedia.com> wrote in message
news:d0kme3$p3k$1@forums.macromedia.com...

> I have two text files, one with product availability and the other with

pricing

> and want to join the two together to produce a price list. I have created

two

> recordsets using txt drivers and this works fine. When trying to create

another

> recordset with a JOIN between the two files I can't.
> Is it just a naming issue in the SQL or is it impossible?
>
> Andrew
>

[tollesbury]

I'm not sure here how I can determine what the field names and types are they
are raw text files.

Below is what I would expect it to be but I get 'syntax error in JOIN
expression'

SELECT * FROM Parts.txt as parts, PartsPrices.txt as prices LEFT JOIN
prices.Scale ON parts.Scale = prices.Scale

Both files have field names in the first line and I have Scale is the first
field in prices.txt and the last of 6 fields in parts.txt

Regards,,

Andrew Gilbert

[Michael Fesser]

.oO(tollesbury)

>I'm not sure here how I can determine what the field names and types are they
>are raw text files.
>
> Below is what I would expect it to be but I get 'syntax error in JOIN
>expression'
>
> SELECT * FROM Parts.txt as parts, PartsPrices.txt as prices LEFT JOIN
>prices.Scale ON parts.Scale = prices.Scale

Try

SELECT *
FROM Parts.txt AS parts
LEFT JOIN PartsPrices.txt AS prices ON parts.Scale = prices.Scale

Micha