Welcome Guest, Not a member yet? Register   Sign In
multiple query and foreach loop
#3

[eluser]CroNiX[/eluser]
client
-id
-name

projects
-id
-client_id
-description

Code:
SELECT client.name, projects.description
FROM client
JOIN projects on client.id = projects.client_id
ORDER BY client.name

will list each client name along with all of their project descriptions


Messages In This Thread
multiple query and foreach loop - by El Forum - 12-27-2013, 05:19 AM
multiple query and foreach loop - by El Forum - 12-27-2013, 09:25 AM
multiple query and foreach loop - by El Forum - 12-27-2013, 09:28 AM
multiple query and foreach loop - by El Forum - 12-27-2013, 10:17 AM
multiple query and foreach loop - by El Forum - 12-27-2013, 10:44 AM



Theme © iAndrew 2016 - Forum software by © MyBB