Hi,

I am switching to Linux and I am new to MySQL.
I can do this in MS SQL:

Given a persons DB and a weddings DB:

persons : ID, NAME
weddings: ID, MANID, WOMANID, DATE

SELECT DATE,
(SELECT NAME FROM PERSONS WHERE persons.ID=wedd ing.MANID) AS MANNAME,
(SELECT NAME FROM PERSONS WHERE persons.ID=wedd ing.WOMANID) AS WOMANNAME
FROM WEDDINGS

Result:
...