MySQL Forums
Forum List  »  General

LETF OUTER JOIN in version 4.0.16
Posted by: VITOR LIMA
Date: March 02, 2005 11:29AM

Hello!

first, i want to apologize my language, because i don't speak english very well.

I'm having some problems with the version 4.0.16 because the "LETF OUTER JOIN" is not implemented.
The query is below:

SELECT DISTINCT e.tipo_equipamento, te.sigla_equipamento
FROM equipamento e, tipo_equipamento te
CROSS JOIN (SELECT r.data_reserva, r.prfcod, ar.hora_inicio, ar.hora_fim, er.id_equipamento
FROM reserva r, aula_reserva ar, equipamento_reservado er
WHERE r.data_reserva = '2005-03-10'
AND r.id_reserva = ar.id_reserva
AND ( (ar.hora_inicio BETWEEN ADDTIME('18:00:00','1') AND '20:00:00')
OR (ar.hora_fim BETWEEN ADDTIME('18:00:00','1') AND '20:00:00')
OR ( (ar.hora_inicio <= ADDTIME('18:00:00','1')) AND (ar.hora_fim >= '20:00:00') ) )
AND ar.id_aula_reserva = er.id_aula_reserva) t
ON t.id_equipamento = e.id_equipamento
WHERE t.id_equipamento IS NULL
AND te.id_tipo_equipamento = e.tipo_equipamento



Anyone know how i can resolve this?

Thanks!

Options: ReplyQuote


Subject
Written By
Posted
LETF OUTER JOIN in version 4.0.16
March 02, 2005 11:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.