OR in Query String

ks in advance. Regards, Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Hold System

yone else built a hold system before that might be able to help me out with some pointers? I hope this makes sense. If not please ask for clarification. As always I appreciate any assistance. Thank you, Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Multi-User Issues

Hey, Maybe just whip something up and let us see. If there is more interest after that then maybe you could do the latter. Regards, Justin Palmer -Original Message- From: Joshua J. Kugler [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 4:54 PM To: [EMAIL PROTECTED] Subject

Multi-User Issues

Hi Joshua, I would love to here more about multi-user issues (like record locking). I searched the archives by the title and by your name with no luck. If you don't feel like going into detail, could you point out some good links to learn more about the subject. Regards, Justin P

RE: Error ?

Hi, Can anyone give me a hint to what this error message is trying to say. Thanks, Justin Palmer -Original Message- From: Justin Palmer [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 1:38 PM To: [EMAIL PROTECTED] Subject: FW: Error ? The query that generated this error

FW: Error ?

The query that generated this error was: SELECT t1. * FROM `wat_student_profile` AS t1, `wat_student_job` AS t2 LEFT JOIN t2 ON t1.student_id = t2.student_id WHERE t1.cv != '' AND t1.sevis_id = '' AND t2.student_id = NULL LIMIT 0 , 30 Regards, Justin Palmer -Origin

Error ?

Hi, I get this error from a query: #1066 - Not unique table/alias: 't2' What does it mean? Can anyone point me to a place where I can look up what these codes actually mean? Any help would be great. Regards, Justin Palmer -- MySQL General Mailing List For list arch

RE: SELECT ?

Hi, Thanks. So what you are saying is if a record is not there it is considered NULL? Regards, Justin Palmer -Original Message- From: Brent Baisley [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 12:54 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: SELECT

SELECT ?

the id is not in another table (The second id will be in the second table someday just not today). Not sure if this is possible at all or not, but thought I would ask. Regards, Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http