Help with Joins

2002-12-21 Thread Jim Hankins
Greetings, I'm very new to Mysql and am trying to work with my first multi-table database project. Here are my two table descriptions. I'm trying to get the correct syntax for a sql query to do the following. Display Ticket.Ticketnum,Ticket.Priority,Ticket.Title,Ticket.Status. I assume

RE: MySQL Command to edit a single record

2002-12-21 Thread Jim Hankins
Jeff, Are you looking for an update table syntax? Example Update tablename Set FullName=Their Full Name where someotherfield=someother value; Careful with this one. As if you omit the where clause it will update every record! -Original Message- From: Jeffrey Ellis [mailto:[EMAIL