Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with left join

Status
Not open for further replies.
snowboardr

snowboardr

Programmer
Feb 22, 2002
1,401
PH
I am trying to join 3 tables and I am having trouble getting it to show values in 1 options row, it shows null values instead for the 3 rows it draws.


Code: 
SELECT sh.sid, sh.sorderid, sh.sproductid, sh.soptionid, prod.pid, prod.pname, prod.pinventory, prod.pinventoryunlimited, opt.opid, opt.oinventory, opt.oinventory, opt.ouinventory 
FROM shopping sh 
LEFT JOIN products prod on sh.sproductid=prod.pid 
LEFT JOIN options opt on sh.soptionid=opt.opid


Regards,

Jason
 
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
438
Chris Miller
Chris Miller
BJZeak
  • Locked
  • Question
need help with .sql insert statement
Replies
1
Views
139
spamjim
spamjim
eizs002
  • Locked
  • Question
Connect MS Access to mysqlDB without ODBC
Replies
3
Views
320
spamjim
spamjim
spamjim
  • Locked
  • Question
Is this resolved by joins?
Replies
1
Views
158
spamjim
spamjim
Nigel Gomm
  • Locked
  • Question
MariaDB ODBC connector 3.1.4 with BEGIN ATOMIC
Replies
1
Views
107
Nigel Gomm
Nigel Gomm

Part and Inventory Search

Sponsor

Back
Top