Search

tbl_payments has foreign key of tbl user,

tbl_user has foreign for tbl_joomla users,

Now i am in the listing of tbl payments, and want to make search, on userName, which is placed in tbl_Joomla_Users,

tbl_payment has no direct relation with tbl_joomla_user

But tbl_joomla_user has direct relation with tbl_user and tbl_user has direct relation with tbl_payments