> Isn't that what I did (but didn't work)?? ::
> select t1.*, IFNULL('*',space(1)) as cBilled
? which table is 'left'? and not sure about mysql syntax, try:
select t1.*, IFNULL(d1.itransid,space(1)) as cBilled
from invoice_details d1
left join transactions t1
on d1.itransid = t1.iid
where t1.iacctid = 32
or
select count(*) as cnt
from invoice_details d1
left join transactions t1
on d1.itransid = t1.iid
where d1.itransid is null
Andrew Davies MBCS CITP
- AndyD 8-)#
**********************************************************************
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email in error please notify the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
Please contact [EMAIL PROTECTED] with any queries.
**********************************************************************
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
