guys,
i have a table which contains 5 fields, of these 2 fields need to be
filled in through an inner join from one same table.
now i have managed to fill in one field using the inner join method.
but the second field also is exactly the same and needs to be filled
in from the same table, the only difference is the field name is
different and obviously the content of these two fields is also
different (but its still coming from the same other table).
so i guess my question is how do i populate two fields using an inner
join (both these fields contain different data but from the same
table). i hope i have been able to explain myself.
thanks.