General information
Category:
Coding, syntax & commands
>I have a client table that has a field postalcode(field-postalcode)
>I have a town table that lists all towns and all possible postal codes for these towns(fields - pcode, town)
>I have a dropdown list that fills from a town.dbf
>
>If user selects Toronto from the list - I want all clients to be displayed where the postal codes match based on the town.
>
> what's the best way to handle this, I'm doing it on a web page / with web connect and visual foxpro database
>
>Any sql samples would be appreciated.
>
>MB
Try:
SELECT clients.* FROM clients
WHERE clients.postalcode IN (SELECT postalcode FROM town WHERE town=)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only