Re: ORDER BY {Lookup field} gets "Lookup has no default value"
- From: "Bill Todd" <no@xxxxxx>
- Date: 11 Dec 2007 16:08:52 -0700
Assuming that the database you are using supports inner joins you can
do:
SELECT C.*, L.CLIENTLOOKUP FROM CLIENTS C JOIN LOOKUPTABLE L
ON C.CLIENTID = L.CLIENTID
ORDER BY L.CLIENTLOOKUP
--
Bill Todd (TeamB)
.
- Follow-Ups:
- Re: ORDER BY {Lookup field} gets "Lookup has no default value"
- From: Ian Groves
- Re: ORDER BY {Lookup field} gets "Lookup has no default value"
- References:
- ORDER BY {Lookup field} gets "Lookup has no default value"
- From: Ian Groves
- ORDER BY {Lookup field} gets "Lookup has no default value"
- Prev by Date: Re: Finding a record number using SQL
- Next by Date: ORDER BY {Lookup field} gets "Lookup has no default value"
- Previous by thread: ORDER BY {Lookup field} gets "Lookup has no default value"
- Next by thread: Re: ORDER BY {Lookup field} gets "Lookup has no default value"
- Index(es):
Relevant Pages
|
