subject:"Help with Query Syntax\?"

Help with Query Syntax?

2001-01-29 Thread Lee Jenkins

Hi all. I'm having a little trouble with this query. **Table 1 (Orders) ** OrderID SmallInt OrderStatus VarChar(20) CustomerPhone VarChar(10) SalesRepIDSmallInt(11) **Table 2 (Customers)** CustomerFirst VarChar(20) CustomerLast

Re: Help with Query Syntax?

2001-01-29 Thread Roger Ramirez

the o.OrderID but I usually like selecting the ID from the main table being queried. - Original Message - From: "Lee Jenkins" [EMAIL PROTECTED] To: "MySQL Mail list" [EMAIL PROTECTED] Sent: Monday, January 29, 2001 10:18 PM Subject: Help with Query Syntax? Hi all.