Re: subselect fails

[Brian Case]

Before I change the foreign key name in the billing table to something else, am I missing a syntax error?

SELECT w.*, b.* FROM project p JOIN workunit w ON p.projectid = w.projectid LEFT JOIN billing b ON w.workunitid = b.workunitid WHERE p.projectid = 9 ORDER BY w.type, w.workunitid ASC";

Result is that
(1) Though workunitid exists in both workunit (w.) and billing (b.) tables, the sql result set shows it only once.
(2) If there is no corresponding workunitid in b., the sql result shows workunitid as NULL (which I guess means the the result set is picking up the b.workunitid, not the w.workunitid.)

I have tried changing the select to read "SELECT w.workunitid, w.*, b.* ..."). Same result.

The number of records in the result set is correct, as are all the workunit and billing fields. Just the workunitid is corrupted.