Sounds like you have the same field name in both tables.  Prefix the table
name on the duplicate field.

-----Original Message-----
From: Ntshalintshali Neliso [mailto:Ntshalintshalin@f...]
Sent: Tuesday, June 12, 2001 12:14 PM
To: sql language
Subject: [sql_language] temporary_table



	Hi,

	I am trying to create a join between a temporary and a permanent
table and I am getting
	an error on my fields, "Ambiguous field..." . All I need to know is
whether joins with temporary
	tables are not meant to work or maybe I have anothe problem with the
Sql statement.

	Thank's,
	Neliso