Member Avatar for tanhc

Hi there, I am a newbie to MSSQL. I apologise first as I know that my question might have been asked by others elsewhere but unfortunately I couldn't find it. I will really appreciate if someone can shed some light into my question.

I have two tables with the following fields respectively:

1. ProjectTABLE
projectid (int)
projectName (varchar)

2. photoTABLE
photoid (int)
projectid (int)
path (varchar)
approved (true or false)

I would like to retrieve the projectid, projectName, (path, where photoTABLE.approved=true), where projectid = @projectid

How can this be possibly done. How the SQL query should be written? Thanks.

  • 3 Contributors
  • 3 Replies
  • 131 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by poojaabora
Member Avatar for kameswari

Hi you can use the following query.
declare approved as 'varchar'

select projectid,projectname,path from projecttable, phototable where projecttable.projectid= phototable.projectid and phototable.appoved like 'true'

Let me know if you face any problem with this query.

Member Avatar for tanhc

Hi there, thanks for the response. It solves my problem. I just realised from your post that what I need is the AND parameter :)

Member Avatar for poojaabora

thanks its really very helpfull in my final year project

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.