RE: Help with Query
| From: | De Necker Henri | Date: | Tue, 23 Oct 2001 05:25:32 +0000 |
| Subject: | RE: Help with Query | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-71896@lists.php.net to get a copy of this message | ||
> 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
>
>
>