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' =
On 14 Jan 2003, at 15:28, Peter van der Kamp wrote:
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
I won't say you need to go back to high school, but maybe you need to
review how SQL works. You have no criterion for joining your two
At least my knowledge of SQL needs an update.
Although there are criteria for joining the two
tables I realize that the way I specified them is
wrong.