Hi again.
My problem now is when I use Cross Join on the record where it should
be null value it give another value.
First I give try without cross join, this is my query :
Code:
SELECT P.name, M.date, M.type, D.invoice_id, D.amount
FROM payment_methods AS P
INNER JOIN
payment_receives AS M ON M.payment_method_id=P.payment_method_id
AND M.date BETWEEN CAST( '2007-09-03 00:00:00' AS Datetime )
AND CAST( '2007-09-03 23:59:59' AS Datetime )
Inner JOIN payment_receive_details AS D ON
M.payment_receive_id=D.payment_receive_id;
It give me 5 record.
I want to make a report base on this data, but my report is on
crosstab report, where there are 3 kind of payment method group.
So I Use this query:
Code:
SELECT G.name,M.payment_receive_id,P.name, M.date, M.type,
D.invoice_id, D.amount
FROM payment_method_groups As G Cross Join
payment_methods AS P
Inner JOIN
payment_receives AS M ON M.payment_method_id=P.payment_method_id
Inner JOIN payment_receive_details AS D ON
M.payment_receive_id=D.payment_receive_id
Where M.date BETWEEN CAST( '2007-09-03 00:00:00' AS Datetime )
AND CAST( '2007-09-03 23:59:59' AS Datetime );
It give me 15 record, but each D.amount value of the empty record has
a value same as the value of the existing record.
My purpose is to create Empty value (Null).
Where do i make an error?
Help please.
Thank you.
Cross Join give value on where it's should be NULL -
09-03-2007
, 05:16 AM
Linear Mode
