Help with query

[unknown1234]

worked it out thanks anyway

[abduraooft]

select Column1,Column2,Column3 .... from TableName ...
order by Column1,Column2

[unknown1234]

yea i got that. but how do i get it so that i get ppl with a mobile number with no home phone number. Also how do i make it so there given names are alphabetical order when familyname is the same. thanks

[Fumigator]

What does your database design look like?

[Old Pedant]

Showing those disconnected thumbnails doesn't tell us whether all those columns are in the same table or in separate tables. And it doesn't tell us the datatypes of the columns.

If you could just dump out the *schema* (table name(s), column names, data types) of your DB that would be tons more useful.

[unknown1234]

thanks got it