[RedFusion]

Hello!

I have this problem with a piece of SQL code which i've been trying to solve for some time.

I have this table which contains deaths. Columns:
deathid
deadvisitid
killervisitid

I also have a table which contains visits. Columns:
visitid
ip
name

Now to the problem:
I'm trying to fetch the full details of every death in the same row, i've tried some different approaches using joins and aliases without reaching my goal.

I have managed to fetch the dead and killer details in separate rows. But what i want is to fetch all of this - deathid, dead ip, dead name, killer ip, killer name - in 1 row.

I really need some help here!

[Freaksken]

If both the information of the victim and killer are in the same table, you will need to perform 2 joins on that table.