All pastes #987299 Raw Edit

Miscellany

public text v1 · immutable
·published 2008-04-16 12:40 UTC
rendered paste body
SELECT tripid, memberid, txttriptitle, txttriptheme, txttriplocation, tblparticipants.txtpartname, txtdepartureplace, DATE_FORMAT(txtdeparturedate, '%M %d, %Y') AS txtdeparturedate, txtdeparturetime, txtarrivalplace, txtarrivaltime, txtreturndepplace, txtreturndeptime, txtreturnarrplace, txtreturndate, txtreturnarrtime FROM tbltripsmain OUTER JOIN tblparticipants ON tbltripsmain.idtripleader = tblparticipants.participantid WHERE memberid = 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OUTER JOIN tblparticipants ON tbltripsmain.idtripleader = tblparticipants.partic' at line 1