.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

Select query to check existence of foreign key

Posted By: Sajid P K     Posted Date: November 25, 2010    Points:2   Category :Sql Server

I have table A & B (One to Many). There is a foreign key in Table B. I have to write a quay to select data from A.

Its one Colum should be a Boolean value.. I.e. it should be True if related value (foreign key) exist in the table B. Other wise it false.

Please advice me efficient way of writing this query?

Author: Sajid P K             
Posted Date: November 25, 2010     Points: 5   
Author: Deco             
Posted Date: November 25, 2010     Points: 5   

Please explain briefly


Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend