[NewToJava2011]

Using phpMyAdmin 5.1.44 to experiment with DML commands.

I've been following tutorials online.

SELECT book.b_isbn, publisher.p_name FROM 'book', 'publisher' WHERE book.b_title='DSA'

Table 1

book

b_id(PK)    b_isbn     b_title   p_id(FK)
-----------------------------------------
1           12345      DSA       1
2           23456      SD        1
3           34567      CSP       2

Table 2

publisher

p_id(PK)    p_name
--------------------
1           Fred
2           John

Expected Results

b_isbn      p_name
---------------------
12345       Fred

Actual Results

b_isbn      p_name
----------------------
12345       Fred
34567       John

Any ideas?

[modi123_1]

Are you trying to do a join? Something like this?

	SELECT book.b_isbn, publisher.p_name FROM 'book' join 'publisher' on book.p_id = publisher.p_id WHERE book.b_title='DSA'