where statement problem

Question

question

Anas asked Dec 27, '16

where statement problem

Select p_firstname, p_email From teacher , borrowed where teacher.p_id and borrowed.p_id =055511 ; the code works perfectly without "where" statement, once i add it, it gives me error. why ?

error where

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2016-12-27T15:23:41Z

JohnM answered Dec 27, '16

The WHERE clause is incorrect. You need to define some type of equality for teacher.p_id. Like this: WHERE teacher.pid = 055511 AND borrowed.p_id = 0555111; Also, your join syntax is outdated. The better way would be to declare an INNER JOIN like this: FROM dbo.teacher t INNER JOIN dbo.borrowed b on t.p_id = b.p_id --(or some matching criteria) Reference: http://straightpathsql.com/archives/2012/11/sql-server-join-syntax-its/ Hope that helps!

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2016-12-27T18:53:10Z

Anas answered Dec 27, '16

![thank you for replying, but unfortunately, it did not work, i uploaded a picture][1] thank you for replying, but unfortunately, it did not work, i uploaded a picture [1]: /storage/temp/3867-lms-database.jpg

lms-database.jpg (148.8 KiB)

4

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM commented · Dec 27, 2016 at 07:25 PM

Try this: SELECT p_firstname, p_email from teacher t inner join borrowed b on t.p_id = b.p_id where t.p_id = '0888654'

0 ·

Anas commented · Dec 27, 2016 at 07:42 PM

still the same result, besides: the borrowed table consist of ids of teachers and students who borrowed books, so i need the "where" to compare the borrowed id table with teacher id table to get only the teachers names and emails who borrowed books (without students )

0 ·

JohnM commented · Dec 27, 2016 at 08:45 PM

What is the table structure for both tables? Can you post that? Can you try this: Select p_firstname, p_email From teacher , borrowed where teacher.p_id = '055511' and borrowed.p_id ='055511' ;

0 ·

Anas commented · Jan 06, 2017 at 08:45 AM

eventually it worked, there was a problem in the structure of some tables... thank you so much for your help and sorry for delay replying

0 ·

question