Hi People,
I'm new in Joins (well I learned the basics here
) but now I ran into a problem:
What I want is to get an array with certain fields from two tables. Later on this sould be soted by timestamp but I struggled with the basics
So here is my select (lil simplyfied):
select a.advance_value, p.orig_time_stamp from dos_advance_nub a, dos_payment_nub p;
The Problem is really easy to explain: As soon as there is no data in dos_payment_nub NOTHING comes back although a.advance_value has a record I didn't tried it vice verca but if it only works when both tables are filled, it is useless for me.
thx
I'm new in Joins (well I learned the basics here
) but now I ran into a problem:What I want is to get an array with certain fields from two tables. Later on this sould be soted by timestamp but I struggled with the basics
So here is my select (lil simplyfied):
select a.advance_value, p.orig_time_stamp from dos_advance_nub a, dos_payment_nub p;
The Problem is really easy to explain: As soon as there is no data in dos_payment_nub NOTHING comes back although a.advance_value has a record I didn't tried it vice verca but if it only works when both tables are filled, it is useless for me.
thx