From: "Marius Stan" <[EMAIL PROTECTED]>

>> SELECT tbl1.col1, tbl2.col1 FROM tbl1, tbl2 WHERE \
>>   tbl1.col2 = tbl2.col2 AND tbl1.col3 = '666';

> Daca folosesti:
>  SELECT tbl1.col1, tbl2.col1 FROM tbl1
> LEFT JOIN tbl2 on tbl1.col2 = tbl2.col2
> WHERE  tbl1.col3 = '666',

Si, btw, Florin nu vrea LEFT JOIN, ci INNER JOIN (sau cum i-o zice in
mySQL).

Mihai

---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to 
unsubscribe from this list.

Raspunde prin e-mail lui