breeze351
asked on
Problem with inner join
I have a query that reads:
$SqlString1 = "SELECT d.SEQ,d.BNMB,d.STRT,b.OWNC DE
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
$SqlString1 = "SELECT d.SEQ,d.BNMB,d.STRT,b.OWNC
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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