The error is not in the join, but in the fact that you have two invoices
with the same invocecode. The items are retrieved and displayed for both
invoices.
If this is correct, select distinct should solve your problem.
On Mon, Jan 12, 2009 at 5:59 PM, Ron wrote:
> Hi All,
>
> I got the followi
Hi All,
I got the following tables:
table items
+-+-++-+--+--+--+
| accountcode | invoicecode | invitemqty | packagecode | itemcode |
packagename | packagedesc |
+-+--
Hi All,
Given this table:
+-+-+++-
|sip_status | sip_method | sip_callid | username |
fromtag| totag
