SQL sorting

[Ruslan Zasukhin]

on 2/13/04 1:41 AM, Florian Bogeschdorfer at fb at memedia.de wrote:

> Hi list!
> 
> I have two tables, each has a date and a time field :
> 
> TABLE1
> myDateField1
> myTimeField1
> Other fields...
> 
> TABLE2
> myDateField2
> myTimeField2
> Other fields...
> 
> 
> Now I would like to make a search over both tables and sort the data first
> by date then by time
> 
> 1. How can I sort by date and after that by time?
> 
> 2. The date fields and time fields have different names in both tables but I
> would like to sort like this:
> 
> TABLE1
> 01.11.2003
> 25.08.2003
> 
> TABLE2
> 10.10.2003
> 
> 
> 
> Wanted result: 
> 25.08.2003
> 10.10.2003
> 01.11.2003
> 
> 
> How can I do this?

For this you need UNION,
Not works in 1.x

You can just self copy records into TMP record.

BTW, UNION will do the same -- build TMP table.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------