Database Error Code: Unknown column 'civicrm_contact.id' in 'on clause', 1054

After installing civicrm on an existing drupal (4.6.3) install, I get an error when I try to view one o the "standard suppled" default contacts. Doesn't matter which conract, the all do it.

Any help appreciated. This is a new install, was just looking at what was there when this error occured.

Regards
Andy

.../civicrm/contact/view?reset=1&cid=11

Apache 1.3.34
PHP 4.4.1
MySQL 5.0.15

Sorry. A non-recoverable error has occurred.

Database Error Code: Unknown column 'civicrm_contact.id' in 'on clause', 1054

Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)

[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => ( SELECT civicrm_relationship.id as civicrm_relationship_id,
civicrm_contact.sort_name as sort_name,
civicrm_address.street_address as street_address,
civicrm_address.city as city,
civicrm_address.postal_code as postal_code,
civicrm_state_province.abbreviation as state,
civicrm_country.name as country,
civicrm_email.email as email,
civicrm_phone.phone as phone,
civicrm_contact.id as civicrm_contact_id,
civicrm_contact.contact_type as contact_type,
civicrm_relationship.contact_id_b as contact_id_b,
civicrm_relationship.contact_id_a as contact_id_a,
civicrm_relationship_type.id as civicrm_relationship_type_id,
civicrm_relationship.start_date as start_date,
civicrm_relationship.end_date as end_date,
civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
civicrm_relationship_type.name_b_a as relation FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_location.entity_id AND
civicrm_location.is_primary = 1 )
LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id) WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id AND civicrm_relationship.contact_id_b = 11 AND civicrm_relationship.contact_id_a = civicrm_contact.id ) UNION ( SELECT civicrm_relationship.id as civicrm_relationship_id,
civicrm_contact.sort_name as sort_name,
civicrm_address.street_address as street_address,
civicrm_address.city as city,
civicrm_address.postal_code as postal_code,
civicrm_state_province.abbreviation as state,
civicrm_country.name as country,
civicrm_email.email as email,
civicrm_phone.phone as phone,
civicrm_contact.id as civicrm_contact_id,
civicrm_contact.contact_type as contact_type,
civicrm_relationship.contact_id_b as contact_id_b,
civicrm_relationship.contact_id_a as contact_id_a,
civicrm_relationship_type.id as civicrm_relationship_type_id,
civicrm_relationship.start_date as start_date,
civicrm_relationship.end_date as end_date,
civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
civicrm_relationship_type.name_a_b as relation FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_location.entity_id AND
civicrm_location.is_primary = 1 )
LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id) WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id AND civicrm_relationship.contact_id_a = 11 AND civicrm_relationship.contact_id_b = civicrm_contact.id ) ORDER BY civicrm_relationship_type_id, sort_name LIMIT 0, 3 [nativecode=1054 ** Unknown column 'civicrm_contact.id' in 'on clause']
[type] => db_error
[user_info] => ( SELECT civicrm_relationship.id as civicrm_relationship_id,
civicrm_contact.sort_name as sort_name,
civicrm_address.street_address as street_address,
civicrm_address.city as city,
civicrm_address.postal_code as postal_code,
civicrm_state_province.abbreviation as state,
civicrm_country.name as country,
civicrm_email.email as email,
civicrm_phone.phone as phone,
civicrm_contact.id as civicrm_contact_id,
civicrm_contact.contact_type as contact_type,
civicrm_relationship.contact_id_b as contact_id_b,
civicrm_relationship.contact_id_a as contact_id_a,
civicrm_relationship_type.id as civicrm_relationship_type_id,
civicrm_relationship.start_date as start_date,
civicrm_relationship.end_date as end_date,
civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
civicrm_relationship_type.name_b_a as relation FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_location.entity_id AND
civicrm_location.is_primary = 1 )
LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id) WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id AND civicrm_relationship.contact_id_b = 11 AND civicrm_relationship.contact_id_a = civicrm_contact.id ) UNION ( SELECT civicrm_relationship.id as civicrm_relationship_id,
civicrm_contact.sort_name as sort_name,
civicrm_address.street_address as street_address,
civicrm_address.city as city,
civicrm_address.postal_code as postal_code,
civicrm_state_province.abbreviation as state,
civicrm_country.name as country,
civicrm_email.email as email,
civicrm_phone.phone as phone,
civicrm_contact.id as civicrm_contact_id,
civicrm_contact.contact_type as contact_type,
civicrm_relationship.contact_id_b as contact_id_b,
civicrm_relationship.contact_id_a as contact_id_a,
civicrm_relationship_type.id as civicrm_relationship_type_id,
civicrm_relationship.start_date as start_date,
civicrm_relationship.end_date as end_date,
civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
civicrm_relationship_type.name_a_b as relation FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_location.entity_id AND
civicrm_location.is_primary = 1 )
LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id) WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id AND civicrm_relationship.contact_id_a = 11 AND civicrm_relationship.contact_id_b = civicrm_contact.id ) ORDER BY civicrm_relationship_type_id, sort_name LIMIT 0, 3 [nativecode=1054 ** Unknown column 'civicrm_contact.id' in 'on clause']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="( SELECT civicrm_relationship.id as civicrm_relationship_id,
civicrm_contact.sort_name as sort_name,
civicrm_address.street_address as street_address,
civicrm_address.city as city,
civicrm_address.postal_code as postal_code,
civicrm_state_province.abbreviation as state,
civicrm_country.name as country,
civicrm_email.email as email,
civicrm_phone.phone as phone,
civicrm_contact.id as civicrm_contact_id,
civicrm_contact.contact_type as contact_type,
civicrm_relationship.contact_id_b as contact_id_b,
civicrm_relationship.contact_id_a as contact_id_a,
civicrm_relationship_type.id as civicrm_relationship_type_id,
civicrm_relationship.start_date as start_date,
civicrm_relationship.end_date as end_date,
civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
civicrm_relationship_type.name_b_a as relation FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_location.entity_id AND
civicrm_location.is_primary = 1 )
LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id) WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id AND civicrm_relationship.contact_id_b = 11 AND civicrm_relationship.contact_id_a = civicrm_contact.id ) UNION ( SELECT civicrm_relationship.id as civicrm_relationship_id,
civicrm_contact.sort_name as sort_name,
civicrm_address.street_address as street_address,
civicrm_address.city as city,
civicrm_address.postal_code as postal_code,
civicrm_state_province.abbreviation as state,
civicrm_country.name as country,
civicrm_email.email as email,
civicrm_phone.phone as phone,
civicrm_contact.id as civicrm_contact_id,
civicrm_contact.contact_type as contact_type,
civicrm_relationship.contact_id_b as contact_id_b,
civicrm_relationship.contact_id_a as contact_id_a,
civicrm_relationship_type.id as civicrm_relationship_type_id,
civicrm_relationship.start_date as start_date,
civicrm_relationship.end_date as end_date,
civicrm_relationship.is_active as is_active , civicrm_relationship_type.name_a_b as name_a_b,
civicrm_relationship_type.name_a_b as relation FROM civicrm_contact, civicrm_relationship, civicrm_relationship_type
LEFT OUTER JOIN civicrm_location ON ( civicrm_location.entity_table = 'civicrm_contact' AND
civicrm_contact.id = civicrm_location.entity_id AND
civicrm_location.is_primary = 1 )
LEFT OUTER JOIN civicrm_address ON (civicrm_location.id = civicrm_address.location_id )
LEFT OUTER JOIN civicrm_phone ON (civicrm_location.id = civicrm_phone.location_id AND civicrm_phone.is_primary = 1)
LEFT OUTER JOIN civicrm_email ON (civicrm_location.id = civicrm_email.location_id AND civicrm_email.is_primary = 1)
LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id) WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id AND civicrm_relationship.contact_id_a = 11 AND civicrm_relationship.contact_id_b = civicrm_contact.id ) ORDER BY civicrm_relationship_type_id, sort_name LIMIT 0, 3 [nativecode=1054 ** Unknown column 'civicrm_contact.id' in 'on clause']"]
)