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
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
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
* [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,
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
