Hi, I have two tables
users and
vendors and user have
mobile no field
"vendor_contact" and
user also have mobile no field
"user_contact".
Now while inserting contact no in user or vendor, i want to check weather that contact no is exist in both tables or not....
i don't have any common field in both tables.
How i ll do this?