Welcome, Guest. Please login or register.

Author Topic: MySQL / PHP Programming (was, what comes next)  (Read 3893 times)

Description:

0 Members and 1 Guest are viewing this topic.

Offline Speelgoedmannetje

  • Hero Member
  • *****
  • Join Date: Oct 2002
  • Posts: 9656
    • Show all replies
Re: MySQL / PHP Programming (was, what comes next)
« on: June 11, 2009, 06:19:35 PM »
Hm, my quick reply on this is you want an inner join
(SELECT * FROM Problems A INNER JOIN solution b ON A.problem_id = B.problem_id)

I take it for granted you have explicitly defined the relations, to ensure referential integrity?
« Last Edit: June 11, 2009, 06:23:54 PM by Speelgoedmannetje »
And the canary said: \'chirp\'