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 JOIN tblparticipants ON tbltripsmain.idtripleader = tblparticipants.participantid WHERE memberid = 1Column 'memberid' in field list is ambiguous