MySQL Forums
Forum List  »  Newbie

Re: Problem with query
Posted by: Gerwin Mueller
Date: July 30, 2005 03:05PM

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

Options: ReplyQuote


Subject
Written By
Posted
July 30, 2005 02:25PM
July 30, 2005 02:47PM
Re: Problem with query
July 30, 2005 03:05PM
July 30, 2005 03:26PM
July 30, 2005 03:27PM


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.