General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>With "SELECT * FROM customer WHERE customer.lastname = ?vp_lastname", it's easy enough to pass "" as the parameter and get all customers, but what about a date(customer.lastdate) or integer(customer.custid)?
>
>You could have either a compound WHERE, or you could have a different view for each type of query. CustomersByLastName, ByDate, ByCustID, etc.
Okay, I hate to sound dense, but can you give me an example of the compound WHERE clause? It sounds like the answer I want, but can't quite see.
SELECT * FROM customers WHERE
custid gives all records OR custid gives one record
Previous
Next
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