> I'm going to send direct from the programming computer, using a different > e-mail address.
Ok, I reply to the list, but CC to you. Think I found your problem... > I did find that I had one invalid foreign key value in table A, but my > problem remains... > > I tried this: > > Database PosenL running on localhost > Showing records 0 - 2 (2 total) > > SQL-query : [Edit] > SELECT L.Name, C.Name, R.Researcher FROM Researchers2Languages R > LEFT JOIN > Languages L ON L.Language = R.Language LEFT JOIN Competencies C ON > C.Competence = R.Competence WHERE R.Researcher = 39 LIMIT 0, 30 > > Name Name Researcher > Native speaker Native speaker 39 > Can read Can read 39 > > Note that I'm still getting C table values in the B value column, > and still > getting the " " on the B column values.... ok... you are obviously using some kind of front-end tool, not the mysql client. The is a html character, in a browser it looks like a space character. It is used in html to prevent a linebreak at that position. Some frontend tools may have a problem with multiple fields with the same name. Try this: SELECT L.Name as LName, C.Name as CName ... > Here are the dumps: I took a quick look, seems ok. I think the above name issue is your problem. You should always try your queries in the mysql client, to eliminate problems related to the front-end tool or script. -- Roger --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
