...

View Full Version : ambiguous



urgido
02-06-2007, 10:56 AM
When I tried to run my script, this error is showing:



Error: Column 'profile_field_id' in from clause is ambiguous
in query: "SELECT `field`.*, `match_field_name`.`name` AS `matching`, `match_field`.`match_type` AS `matching_type` FROM `date_profile_field` AS `field` LEFT JOIN `date_link_profile_field_match` AS `match_field` ON `field`.`profile_field_id`=`match_field`.`match_profile_field_id` LEFT JOIN `date_profile_field` AS `match_field_name` USING ( `profile_field_id` )"


Regards :)

guelphdad
02-06-2007, 01:39 PM
Don't use USING at any time. It isn't standard SQL.
name the tables.columns you are joining those tables on.

urgido
02-07-2007, 10:19 AM
so, the solutions is just delete the USING phrase?

guelphdad
02-07-2007, 06:31 PM
the solution is to remove the USING clause and use an ON clause with the appropriate columns named from both tables that you are joining on.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum