SQL Server Performance

i want this answer

Discussion in 'ALL SQL SERVER QUESTIONS' started by ranjithkumar, Feb 12, 2013.

  1. ranjithkumar New Member

    iam having products table in that i have pid as a primary key and i having proimage table in that pid is a foreign key it is duplicated i wnt to stop it
    products table proimage table

    pid pname price Pimagid pid path code
    1 ra 100 1 1 2.jpg 2
    2 rt 200 2 1 3.jpg 2

    what my problem is i want to display only one pid=1 image while retriving
  2. admin Administrator

    Hi Ranjithkumar, Welcome to the forums.

    To get a good answer I would suggest firstly using a title that describes the problem. Also a little more detail about the problem would be good, what have you done so far, anything else you have tried to fix the issue.
  3. ranjithkumar New Member

  4. FrankKalis Moderator

    Are you that new to online communities and basic netiquette or do you really think such a subject and now this reply will get you any problem-related answer?

Share This Page