> Hi there. > > I have the following question for u. > I want to join two tables but it must be displayed in the a specific > format. > > The data of the tables are as follow : > > Table employee : > > id surname initials ba > 1 Poep H ER > 2 Snot C ER > 3 Skoen AS ER > 4 Sak Q WQ > > > Table courses_completed : > id course_id completed > 1 WH1.1 Yes > 1 WH1.2 Yes > 1 WH1.3 Yes > 2 WH1.1 Yes > 2 WH1.2 Yes > 3 WH1.1 Yes > 3 WH1.2 Yes > 3 WH1.4 Yes > 3 WH1.5 no > 4 PS1.1 Yes > 4 PS1.2 Yes > 4 PS1.5 Yes > 1 PS1.2 Yes > 1 PS1.2 Yes > > I want to have the following data in a temp table or query : > > id surname initials ba WH1.1 WH1.2 > WH1.3 WH1.4 > 1 Poep H ER Yes Yes > Yes Yes > 2 Snot C ER Yes Yes > Yes Yes > 3 Skoen AS ER Yes Yes > Yes Yes > > id surname initials ba PS1.1 PS1.2 > PS1.4 PS1.5 > 1 Poep H ER Yes Yes > Yes Yes > 4 Sak Q WQ Yes Yes > Yes Yes > > I want to make all the copies of person listed in the rows listed just in > one row,with all his skills listed in colums in that some row. > The information above must be displayed in Exel just like this.There is > about 50 of these courses in one production line,and there is 8 production > lines. > > Is there a way that i can do this or how must i join this tables to get a > table in that form? > > thank u > hoender > > >
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
