×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I'm joining 3 tables, clients, addresses and clientadresses to get the clients living in a town.
What determines the order of the select?
They seem to be mostly in the order of the fields in the select.
If I pagedown then pageup again I get :
Opération de lecture impossible pour le membre CLIENTS. (C I)
Is this a bug? I can't reply to the message!
SELECT clientName RRN(clients), id
FROM
CLIENTS join CLIENTADDRESS on CLIENTS.id=clientAddress.clientID
join ADDRESSES on clientAddress.addressID=ADDRESSES.ID
WHERE ADDRESSES.TOWN = 'PARIS'
Thanks.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
