Credit card assigned to an employee
i am trying to join iby_creditcard and ap_cards_All
using iby_creditcard.instrid=ap_cards_All.card_reference_id
But i am getting 2 rows in ap_Cards_all table for one value of card_referece_id.
Both rows are identical expect card_id.
Please let the significance of card_id and card_reference_id??
Aim:To find out the employes assigned to a card number.
Thanks
Ashish