D]
To: mysql
cc:
Subject:Need 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
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 info
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
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 on
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 ou