s_No DESC
LIMIT 100
It works for me.
Regards!
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 03 de Noviembre de 2005 03:55 p.m.
Para: MySQL List
Asunto: report from two tables
Hi,
I have two table for orders and I have to create a Report with list
ROTECTED]
Enviado el: Jueves, 03 de Noviembre de 2005 03:55 p.m.
Para: MySQL List
Asunto: report from two tables
Hi,
I have two table for orders and I have to create a Report with list of
orders from both tables for specific day.
I made Reports for each table and they work just fine, but don&
Hi,
I have two table for orders and I have to create a Report with list of
orders from both tables for specific day.
I made Reports for each table and they work just fine, but don't know
how to "put them together":
Query for Order Table 1:
SELECT o.Trans_No, o.SoldBy, sm.LName, sm.FName, sm.
