Problem with inner join

I have a query that reads:
$SqlString1 = "SELECT d.SEQ,d.BNMB,d.STRT,b.OWNCDE
                  FROM survey_data d
                  INNER JOIN bld2 b
                  ON d.SEQ = b.SEQ
                  WHERE d.SEQ = 'NY1035000575'";

It returns an error message that the "Query returned nothing".
If I delete the "b.OWNCDE" on the select, it works.

I know that there is an id in both "survey_data" and "bld2" that match.

What am I doing wrong?

Glenn
breeze351Asked:
Who is Participating?
 
Daniel WilsonCommented:
"Query returned nothing" is not a MySQL error.  I'm guessing that something else is reporting that and masking an actual MySQL error.

Are you quite sure OWNCDE is the correctly spelled name and it belongs to table bld2?
0
 
breeze351Author Commented:
Thanks!!!
Can I kill my partner now.  The variable is a code for the owner.  He e-mailed me that it was "OWNCDE", which makes sense.  It's not!!!!  It's "OWCDE".

Thanks again
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.