Kasper K wrote:
> Walter Vaughan skrev:
>> T-SQL is Microsoft's version of SQL. If you would write what you
>> want in Microsoft's version of SQL, someone here might be able to
>> come up with a work around for MySQL.
>
> It wouyld be something like this:
>
> persons : ID, NAME
> weddings: ID, MANID, WOMANID, DATE
>
> SELECT DATE,
> (SELECT NAME FROM PERSONS WHERE persons.ID=wedding.MANID) AS MANNAME,
> (SELECT NAME FROM PERSONS WHERE persons.ID=wedding.WOMANID) AS
> WOMANNAME FROM WEDDINGS
>
> Result:
>
> DATE MANNAME WOMANNAME
> 2000-01-01 John Mary
> 2000-01-05 Johnny Betty
>
>
> A query where i can make more than one select and where statement..
> I hope you are able to help me.

SELECT weddings.Date, persons1.Name AS manname, persons2.name AS womanname
FROM `weddings`
JOIN persons AS persons1 ON weddings.manid = persons1.id
JOIN persons AS persons2 ON weddings.womanid = persons2.id