Revisions to Select count(id) from one table where that id is present in another table MYSQL

Post Undeleted by Jack

occurred Apr 20, 2012 at 2:35

added 23 characters in body

edited Apr 20, 2012 at 2:32

Im not sure if I understood the question correctly.

 SELECT b.ID, a.ID FROM table_a a, table_b b WHERE a.ID = b.ID   AND b.ID = 1

Im not sure if I understood the question correctly.

 SELECT b.ID, a.ID FROM table_a a, table_b b WHERE a.ID = b.ID

 SELECT b.ID, a.ID FROM table_a a, table_b b WHERE a.ID = b.ID AND b.ID = 1

Post Deleted by Jack

occurred Apr 20, 2012 at 2:30

answered Apr 20, 2012 at 2:26

Im not sure if I understood the question correctly.

 SELECT b.ID, a.ID FROM table_a a, table_b b WHERE a.ID = b.ID

Return to Answer