I think you want to try 'having mo.date IS NULL' after the order by.
Daren wrote:
I'm query for a list of offers from a table, but am
trying to do a Left Join on the table that keeps track
of which members have completed which offers (so that
the query will not return offers that the member has
alr
I'm query for a list of offers from a table, but am
trying to do a Left Join on the table that keeps track
of which members have completed which offers (so that
the query will not return offers that the member has
already completed).
Query:
select distinct(ol.id) as id, mo.date from
offers_listin
* [EMAIL PROTECTED]
> I'm new to MySQL and have tried many attempts myself and looked
> all over for
> this answer to no avail. How do I write MySQL joins to accomodate the
> Oracle equivalent listed belowany help would be appreciated.
>
> From
> iteration,
> story,
> person tracker,
I'm new to MySQL and have tried many attempts myself and looked all over for
this answer to no avail. How do I write MySQL joins to accomodate the
Oracle equivalent listed belowany help would be appreciated.
From
iteration,
story,
person tracker,
person customer,
person develope
Have a problem with this query, when xBatch is empty or at least seems
to be empty.
Using DWMX, MySQL, and PHP
SELECT donations.id, donations.batch, donations.oikos_id,
donations.giftDate, donations.genFund, donations.misFund,
donations.benFund, donations.notes, oikos.id, oikos.famLabel
FROM d
