4 - Consultas

From Grupo2 Ahand

(Difference between revisions)
Line 1: Line 1:
-
<table border="1" width="78%" cellspacing="1" id="table1">
+
 
-
<tr>
+
-
<td><font face="Courier New"><b><font color="#FF0000">SELECIONA TODAS AS
+
-
OCORRÊNCIAS DO MOTORISTA </font></b><br>
+
-
SELECT OM.*, M.NOME, M.ID_MOTORISTA FROM motoristas AS m,
+
-
ocorrencias_motoristas AS om<br>
+
-
WHERE m.id_motorista = om.id_motorista GROUP BY M.ID_MOTORISTA;</font><p>&nbsp;</td>
+
-
</tr>
+
-
</table>
+

Revision as of 08:57, 15 December 2006

Personal tools