I need your help with a SQL query
I need the value selected in the table Where the math element is the most orderly order, I currently have the following questions:
SELECT p.confirmation, p.lname, P.fname, p. Profile, A.Edress 1, AACT, c. Leave contact contact p from p.confirmation = c.profileid and c ORD = 1 left on a contact p. Configuration = A .profileid and a.ord = 1 This work is fine when the smalest "a.ord" or c.ord "1. But the smallest value will not always be one, This could be another digit, so I did not give any success to the following:
SELECT p.confirmation, p.lname, p.fname, p.profiletype, a.address1, a ON.P.confirmation = c.profileid min (c.ord) LEFT JOIN one ON p.confirmation = a.profileid min (a.ord) address on contact contact except ccontactinfo profile page. I have replaced "AND a.ord = 1" by "end (a.ord)".
I can do this for two different queries.
Is there a way that I can add something in the type of
Contact
No comments:
Post a Comment