Re: Problem with query
Baris Cicek wrote:
> You should join the tables and get the query like
> that:
> select nr, timefrom, timeto, price_week,
> prive_day, v14_12 .... from a_saison, a_prices,
> a_saison where
> nr='$saisnnr' AND a_prices.typ='$typ';
Hi Baris,
thanks for your reply -
I tried, but the result says: #1066 - Not unique table/alias: 'a_saison'.
So I tried to leave out the second 'a_saison' - result: #1052 - Column: 'nr' in field list is ambiguous
Any idea?
Thanks again,
Gerwin
Subject
Written By
Posted
Re: Problem with query
July 30, 2005 03:05PM
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.