Please I need to create an SQL query to do the following. I have two tables : "Informations" and "Disponibilities"
Table 1 ==> "Informations" :
email | Name |
[email protected] Name 1
[email protected] Name 2
Table 2 ==> "Disponibilities" :
email | Day | Hour_start | Hour_finish
[email protected] Monday 14h 18h
[email protected] Tuesday 16h 17h
[email protected] Wednesday 12h 20h
[email protected] Thursday 08h 10h
[email protected] Friday 18h 19h
[email protected] Monday 10h 13h
[email protected] Tuesday 15h 17h
[email protected] Wednesday 16h 19h
[email protected] Thursday 18h 10h
[email protected] Friday 17h 19h
...
I need as a result a table like this :
email | Name | Day | Hr_start | Hr_finish | Day | Hr_start | Hr_finish | ...
[email protected] Name 1 Monday 14h 18h Tuesday 16h 17h
[email protected] Name 2 Monday 10h 13h Tuesday 16h 17h 15h 17h
Is there any possibility to do this using a query ?
Please help me because I really have no idea about how to do this.
Thanks in advance.
