Query Tables

[nigeloliveros]

I have table Borrower and A BookBorrowed both contains Borrower_ID , From Borrower , Borrower is PK .

I want to Select all borrower names , on the table of BookBorrowed. Is it possible.

[jmcilhinney]

Yes, it is possible. You should look into joins, particularly inner joins in this case.

[dday9]

I have moved this to the Database Development forum. Also, please specify what database and version you're using (MySql, Sql Server, Access, etc.).

Essentially you'd perform an inner join command in your From clause:

SELECT
  `borrower`.`name`,
  `book_borrowed`.`name`
FROM `borrower`
  INNER JOIN `book_borrowed` ON `borrower`.`borrower_id` = `book_borrowed`.`borrower_id`;

Fiddle: Live Demo

[nigeloliveros]

https://dropmb.com/download/47da3489...9270b882c.html

Please look at my database.
I just want, that everytime theres new record in borrow_book I can get the Borrower ID and Borrower name

[dday9]

I just want, that everytime theres new record in borrow_book I can get the Borrower ID and Borrower name

Sweet, with the code that I provided you in Post #3 you can do just that with minimal changes.

[nigeloliveros]

Sweet, with the code that I provided you in Post #3 you can do just that with minimal changes.

Thanks it works now.
But how can I delete duplicate borrower ID?

[dday9]

Do you actually want to delete the rows that contain duplicate borrower_id values or do you just want to exclude them from the query?

[nigeloliveros]

Do you actually want to delete the rows that contain duplicate borrower_id values or do you just want to exclude them from the query?

I just want to display 1 record only if theres two for that particulat borrower..

[dday9]

OK, you can do that by using the GROUP BY clause on your borrower_id column:

SELECT
  `borrower`.`name`,
  `book_borrowed`.`name`
FROM `borrower`
  INNER JOIN `book_borrowed` ON `borrower`.`borrower_id` = `book_borrowed`.`borrower_id`
GROUP BY(`borrower`.`borrower_id`);

Fiddle: Live Demo

Also, to help you understand some of the terminology, whenever you say that you want to delete value(s) generally that means that you literally want to remove them from the data table and not get them back. In this case, your followup question should have been:

How can I get distinct values if the borrower_id column has duplicates?

[nigeloliveros]

OK, you can do that by using the GROUP BY clause on your borrower_id column:

SELECT
  `borrower`.`name`,
  `book_borrowed`.`name`
FROM `borrower`
  INNER JOIN `book_borrowed` ON `borrower`.`borrower_id` = `book_borrowed`.`borrower_id`
GROUP BY(`borrower`.`borrower_id`);

Fiddle: Live Demo

Also, to help you understand some of the terminology, whenever you say that you want to delete value(s) generally that means that you literally want to remove them from the data table and not get them back. In this case, your followup question should have been:

How can I get distinct values if the borrower_id column has duplicates?


I just want to display 1 record for each duplicate record, but not necessarily delete the data in the tables.

[dday9]

With the code that I provided...