🚀 go-pugleaf

Rick_oj escribi�:
> 
> pero si elijo c.rut o p.rut continua entregando errores, lo que finalmente 
> hice fue select * al final...

Me piqu� :p


mysql> select * from clientes;
+-----+------------+-----------+----------+-----------+
| rut | ap_paterno | ap_matern | nombres  | compra    |
+-----+------------+-----------+----------+-----------+
| 111 | ap1        | am1       | nombres1 |           |
| 222 | ap2        | am2       | nombres2 | efectuada |
+-----+------------+-----------+----------+-----------+
2 rows in set (0.00 sec)

mysql> select * from productos;
+-----+-------+
| rut | items |
+-----+-------+
| 111 | A     |
| 222 | B     |
+-----+-------+
2 rows in set (0.00 sec)

mysql> SELECT `ap_paterno`,`ap_matern`,c.`rut`,`items`
     -> FROM clientes c join productos p
     -> WHERE c.rut=p.rut and c.compra='efectuada';
+------------+-----------+-----+-------+
| ap_paterno | ap_matern | rut | items |
+------------+-----------+-----+-------+
| ap2        | am2       | 222 | B     |
+------------+-----------+-----+-------+
1 row in set (0.00 sec)

mysql>





rro