Board index   FAQ   Search  
Register  Login
Board index PHP PHP General

complex query

General discussions related to php

Moderators: macek, egami, gesf

complex query

Postby atxis » Thu Aug 16, 2012 9:11 am

Hi
I have a problem with a complex query, I hope someone can help me.
I have a table with a school classrooms: 1A, 1B, 2A, ...
I have another table with all schedules, with the following fields: "Teachers", "Monday_sub1" (subject of Monday in the first session), "Monday_sub2" ..... "Monday_cl1" (classroom on Monday in the first session) "Monday_cl2" ....
What I want is a query with which to obtain a table where each row is: "Classroom", "Monday_asig1", "Monday_asig2" ...
I tried to use multiple INNER JOIN and WHERE but no way.
Anyone could give me some clue about how?
Thanks!
atxis
New php-forum User
New php-forum User
 
Posts: 1
Joined: Thu Aug 16, 2012 8:59 am

Return to PHP General

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.