I have added a button to a card and am trying to link tables to my new button field, but not sure how to link gp tables to a field. Then once I do that I want to add the table's field's to parameters for a stored proc that is executed on the button's On_Click Event. I have my stored procedure...
I have a query with 3 tables ('Table A', 'Table B', and 'Table C') joined and am getting to many non distinct rows.
I want to have all the fields returned where all fields in table A are distinct and 1 distinct field in Table's B and C.
For instance I want to be able to write:
select...
I have a table customer with the following fields
customerID,CustomerName,Address,City,state,zip. I am trying to write a query
to display all these fields only where the zipcode fields are the same.
My query looks somthing like this:
I have a table customer with the following fields...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.