Louie,
The inner-join is just joining the two tables, shopcart and items.
I think iip is an alias for items, but the alias would normally come
after the name of the tiems table. Another way to write the query is
(assuming iip is an alias for items),
SELECT * FROM shopcart, items iip
WHERE
Message -
From: David Griffiths [EMAIL PROTECTED]
To: Louie Miranda [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June 04, 2004 3:44 PM
Subject: Re: What does this sql query mean?
Louie,
The inner-join is just joining the two tables, shopcart and items.
I think iip is an alias
On 04-Jun-01 Harsh wrote:
I have a table1 in mySQL with the following recordset :
+++-+
| siteno | deptid | agentid |
+++-+
| 0 | 27 | 35 |
| 0 | 25 | 30 |
| 0 | 19 | 30 |
| 0 | 19 | 26
