Hello, I'm working with mySQL 3.23.32 under Solaris. I have a database with two tables 'bron' and 'topic'. Those tables are related via 'naam_bron'. Lets say that table 'bron' contains 100 records where column 'media' = 'Book' and table 'topic' contains 30 records where column 'topic_code' = '5.1'. What should be the result when I issue the following query: select naam_bron from bron, topic where (bron.media="Book") or (topic.naam_bron = bron.naam_bron and topic.topic_code = "5.1");
Before posting my results I'll wait for your answers so I can see if there's a bug in 3.23.32 or that I need to return to highschool :) Thanks, Peter van der Kamp --------------------------------------------------------------------- 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