I have a MySQL table called 'services':

tbl_services
servid
servlangs
servlangt

'servlangs' and 'servlangt', get their values from a table 'language':

tbl_language
langid
langname

I can add records to the service table with no problem.

The trouble starts when I present the records in a repeat region. I have a recordset, to filter the data:

rsServices
SELECT tbl_service.servid, tbl_service.servlangs, tbl_service.servlangt, tbl_language.langname as servlangsource
FROM tbl_service, tbl_language
WHERE tbl_language.langid=tbl_service.servlangs

The repeat region is as follows:

rsServices.servtitle, rsServices.servlangsource, rsServices.servlangt

I've used the 'as servlangsource' to show the language name, instead of the id, but I can't figure out how to do the same for the 'servlangt' value.

Can anybody help?