469,358 Members | 1,578 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,358 developers. It's quick & easy.

Another SQL Question

I've got a working SQL statement here that I'm trying to do a an "Order
By df.Name".

What the SQL does is pulls all data excluding duplicate data from a
second table and taking what ever ID's that's left and looking it up in
a separate look up table. However, when I pull the data I'm not sure
how to Sort the data by df.Name.

I've probably made this SQL statement overly complicated so any help in
tweaking it would be appreciated also.
~~~Original SQL~~~~~
SELECT acd.AvailDispFieldID, df.Name, df.DisplayFieldID
FROM ct_AvailChannelDispField acd, ct_Displayfield df
WHERE acd.ChannelID = '1'
AND (acd.DisplayfieldID = df.DisplayfieldID)
MINUS
SELECT ucd.AvailDispFieldID, df.Name, df.DisplayFieldID
FROM ct_UserChannelDisplayField ucd, ct_Displayfield df,
ct_AvailChannelDispField acd
WHERE ucd.UserChannelID = '1'
AND (ucd.AvailDispFieldID = acd.AvailDispFieldID)
AND (acd.DisplayfieldID = df.DisplayfieldID)
Jul 19 '05 #1
0 1113

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by terence.parker | last post: by
reply views Thread by Sebastian Hiller | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.