Hi,
Im just a new comer on mysql and i was in the middle of debugging some codes
that aint mine. I was stuck here. I could not figure what does this select
do?
Its complicated..
Can anyone help me out?
select * from shopcart inner join items on shopcart.itemId = iip.itemId
where
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