MySQL Forums
Forum List  »  Other Migration

Re: MySQL 4.0 => 5.0 - strange...
Posted by: Andy Pieters
Date: January 26, 2006 09:05AM

I have the same problem if anyone had a solution please reply.

SQL/DB Error -- [Unknown column 'documenten.type_id' in 'on clause']

SELECT documenten.*, document_map.*, document_type.*, bedrijven.naam AS bedrijfs_naam FROM documenten,document_map LEFT OUTER JOIN document_type ON document_type.type_id = documenten.type_id LEFT OUTER JOIN bedrijven ON bedrijven.bedrijf_id = documenten.bedrijf_id WHERE documenten.document_id = document_map.document_id AND document_map.map_id='0' ORDER BY naam

Options: ReplyQuote


Subject
Views
Written By
Posted
4060
January 25, 2006 04:49AM
Re: MySQL 4.0 => 5.0 - strange...
2486
January 26, 2006 09:05AM
2620
January 26, 2006 08:20PM
2514
January 31, 2006 01:25PM
2877
February 03, 2006 06:00PM
2294
February 04, 2006 02:21PM
2358
February 05, 2006 04:30PM
2441
February 02, 2006 01:23PM
2864
February 03, 2006 06:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.