Heyho folks,
I am sitting now for a few weeks on a tricky problem. I don't get it - maybe
anyone of you could give me a hint.
Let's say I have two tables :
Table One has a lot of information about travels, hotels, flights etc.
Table Two has an entry for each hotel and each day where I store
help with JOIN
Heyho folks,
I am sitting now for a few weeks on a tricky problem. I don't get it -
maybe
anyone of you could give me a hint.
Let's say I have two tables :
Table One has a lot of information about travels, hotels, flights etc.
Table Two has an entry for each hotel and each day
Hello,
I have 2 tables(pics and outings)
pics
pic_id, tinyint
path, varchar
outings
outings_id, tinyint
pic1_id, tinyint
pic2_id, tinyint
pic3_id, tinyint
pic4_id, tinyint
When i try to do a join like this
mysql_query(SELECT * FROM pics inner join outings on
outings.pic1_id=pic.pic_id and
Mike,
With the way you have it written below, all of the pic1_id, pic2_id,
pic3_id, and pic4_id must be equal (because they all equal pic.pic_id).
Since this wasn't true for any of the rows, that is why you were
getting no results.
To get each picture value seperately, you will have to do
Thanks for the help. Got that to work no problem.
Mike
- Original Message -
From: Harrison C. Fisk [EMAIL PROTECTED]
To: Mike [EMAIL PROTECTED]
Cc: mysql list [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 5:48 PM
Subject: Re: Need Help with JOIN
Mike,
With the way you have