In response to Greenhorn :
> >
> > Use a left join instead?
> Hi,
> Yes, but when i use a where clause on my query it only selects joined
> records. :(
> Thanks.
Please, answer to the list and not directly to me.
The WHERE-Clause works after the JOIN - so your select contains (without
the WHERE)
In response to Greenhorn :
> Hi,
>
> I'm trying to retrieve all meter_id from table meter, and for meter_id
> without amount, I'd like it to show nothing, 'null'. I've used right
> join here but it's not giving me my desired result. Is there another
> way to do this? Here's the query I'm trying
Hi,
I'm trying to retrieve all meter_id from table meter, and for meter_id
without amount, I'd like it to show nothing, 'null'. I've used right
join here but it's not giving me my desired result. Is there another
way to do this? Here's the query I'm trying.
Thanks in advance!
select m.meter_i
