Defryn,
Monday, July 08, 2002, 5:09:51 AM, you wrote:
D> Can anyone have a look at my join.
D> It returns errors
D> Select O.name, O.amount , P.Productname, P.price
D> From Orders AS O
D> JOIN Products AS P ON O.product=P.Productid
D> Where O.cluster= 'ANP';
D> It works fine when I use
D> Sel
sql,query
Can anyone have a look at my join.
It returns errors
Select O.name, O.amount , P.Productname, P.price
>From Orders AS O
JOIN Products AS P ON O.product=P.Productid
Where O.cluster= 'ANP';
It works fine when I use
Select O.Name, O.amount, P.productname , P.price
>From Orders as O,
