Newbie trying the impossible?

[Scott Hamm]

I could understand this simple SQL statement:

SELECT 
    Associates.LastName + ', ' + Associates.FirstName as name,
    Production.Hours,
    Production.Quantity
FROM 
production,
Associates
WHERE
Associates.ID=Production.OID;

Would produce full name in table.

However when I used left join (trying to learn it) I issued this command:

SELECT 
        QA.OperatorID, 
        QA.QAID, 
        QA.BrandID,
        QA.Batch, 
        QA.KeyDate,
        Batch.[Order],
        Batch.Errors,
        Batch.Comments
FROM
        QA
Left Join
        Batch
ON
        (Batch.QAID=QA.ID)
WHERE
        ID='77363';

How do I get around to it with 2 different names that uses SAME table?

QA.OperatorID (operator)
QA.QAID (reviewer)

Or am I asking for the impossible?



-- 
Power to people, Linux is here.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]