Home » RDBMS Server » Server Administration » one product , different name and display name
one product , different name and display name [message #372277] Wed, 24 January 2001 15:42 Go to next message
Mike
Messages: 417
Registered: September 1998
Senior Member
I have a table called Products. ProductId is primary key.It's fields include ProductName and Displayname.
How do I get list of the products which have different ProductName and Displayname for a ProductId
Thanks
Mike

Report message to a moderator

Re: one product , different name and display name [message #372280 is a reply to message #372277] Wed, 24 January 2001 17:50 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select productid,pname,dname from products
where pname<>dname

Report message to a moderator

Previous Topic: Question about parsing.
Next Topic: free ocp papers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 00:36:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.