More Join Problems
Posted: Wed Nov 03, 2004 12:33 am
Still not 100% sure on how JOINS work, so it's a lot of guess and check goin on here. A lot of the documentation talks about foreign key relationships, and keys are another thing I'm a little cloudy on.
Anyway, here's what I'm trying to execute:
And it's returning:
Whereas it should return:
Hope this isn't too much.
Anyway, here's what I'm trying to execute:
Code: Select all
SELECT u.username, p.product_id, up.thumb_path FROM users AS u, uploads AS up INNER JOIN products AS p ON up.product_id = p.product_idCode: Select all
CanadaMan102 RnVybml0dXJl-TW92YWJsZQ==-0 members/steveo31/microwave_thumb.jpg
steveo31 RnVybml0dXJl-TW92YWJsZQ==-0 members/steveo31/microwave_thumb.jpg
CanadaMan102 VG9vbHM=-VG9vbHM=-1 members/steveo31/tools_thumb.jpg
steveo31 VG9vbHM=-VG9vbHM=-1 members/steveo31/tools_thumb.jpg
CanadaMan102 SGFyZHdhcmU=-RWxlY3RyaWNhbA==-2 members/steveo31/blender_thumb.jpg
steveo31 SGFyZHdhcmU=-RWxlY3RyaWNhbA==-2 members/steveo31/blender_thumb.jpg
CanadaMan102 QXV0b21vYmlsZXM=-Q2Fycw==-3 members/steveo31/modelt_thumb.jpg
steveo31 QXV0b21vYmlsZXM=-Q2Fycw==-3 members/steveo31/modelt_thumb.jpg
CanadaMan102 SGFyZHdhcmU=-RWxlY3RyaWNhbA==-4 members/steveo31/toaster_thumb.jpg
steveo31 SGFyZHdhcmU=-RWxlY3RyaWNhbA==-4 members/steveo31/toaster_thumb.jpg
CanadaMan102 VG9vbHM=-VG9vbHM=-5 members/steveo31/wrech_thumb.jpg
steveo31 VG9vbHM=-VG9vbHM=-5 members/steveo31/wrech_thumb.jpgCode: Select all
steveo31 RnVybml0dXJl-TW92YWJsZQ==-0 members/steveo31/microwave_thumb.jpg
steveo31 VG9vbHM=-VG9vbHM=-1 members/steveo31/tools_thumb.jpg
CanadaMan102 SGFyZHdhcmU=-RWxlY3RyaWNhbA==-2 members/CanadaMan102/blender_thumb.jpg
steveo31 QXV0b21vYmlsZXM=-Q2Fycw==-3 members/steveo31/modelt_thumb.jpg
steveo31 SGFyZHdhcmU=-RWxlY3RyaWNhbA==-4 members/steveo31/toaster_thumb.jpg
CanadaMan102 VG9vbHM=-VG9vbHM=-5 members/CanadaMan102/wrech_thumb.jpgHope this isn't too much.