Hi all,
we have this query that doesn't run. It seems, that it is not possible
to work with subqueries.
If subqueries are running, what do we make wrong? Or, what do we have to
change?
The problem is at "and zielflug in (select...".
Thanks for your help in advance!
Thomas
$res=mysql_query ("select distinct date_format(abflugdatum,
'%d.%m.%y'),date_format(rueckreisedatum,'%d.%m.%y'),verpflegung, min(preis) as low
,hotelname,hotelort,sterne, hotelcode,dauer from $Start where to_days(abflugdatum)
>=to_days(concat(right('$datum',2),mid('$datum',4,2),left('$datum',2))) and
to_days(abflugdatum)
<=(to_days(concat(right('$datum',2),mid('$datum',4,2),left('$datum',2)))+'$plus') and
zielflug in (select distinct kurz from zielregion where land='$Zielregion') and sterne
>= '$kategorie' and preis <= '$Preis' and dauer >= ('$dauer' - '$dplus') and
dauer <= ('$dauer' + '$dplus') and belegung='$unterbringung' and
verpflegung='$verpflegung' group by abflugdatum, rueckreisedatum, hotelname, hotelort
order by low");

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.